=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" wrote in message
...
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"