sumif across multiple sheets
I have the following formula that I am trying to use but the result is #VALUE:
=SUMIF(Sheet1:Sheet9!B1,"PMI",Sheet1:Sheet9!A3)
The formula should look in cell B1 of each sheet and if it is equal to "PMI"
sum of the value in cell A3 in each sheet.
What am I doing wrong or is this possible?
Thanks
|