Average calcs - ignore sheets

B

Blackstar79

How could I Calculate average of each cell in multiple sheets ex
(‘sheet1’!b10,’sheet31’!b10) but ignore sheets where ex: cell b3 says
“Saturdayâ€
 
B

Bob Phillips

=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1:3"))&"!B3"),"<>Saturday",
INDIRECT("Sheet"&ROW(INDIRECT("1:3"))&"!B10")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top