ExcelBanter - Average calcs

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Average calcs - ignore sheets (https://www.excelbanter.com/excel-worksheet-functions/98967-average-calcs-ignore-sheets.html)

Blackstar79

Average calcs - ignore sheets

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

Average calcs - ignore sheets

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

All times are GMT +1. The time now is 02:37 PM.