hi,
here is what i am trying to do. i have a formulas that either SUM or AVERAGE cells across 70 workheets. now i need to make the same calculations, but only for sheets that have a specific value in one cell.
ex: sum of cell B1 only in worksheets where A1="x".
i have tried these SUMIFs:
=SUMIF('sheet1:sheet70'!A1, x, 'sheet1:sheet70'!B1)
=SUMIF('sheet1:sheet70'!A1, x, ['sheet1:sheet70'!B1])
but apparently SUMIF does not work across multiple worksheets ranges?
is there any way to do this?
Bookmarks