Average calcs - ignore sheets

[Guest]

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â€

 

[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)