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”

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

"Blackstar79" <(E-Mail Removed)> wrote in message
news:38437A3A-7DE0-4EEC-BEB0-(E-Mail Removed)...
> 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"