|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
sumif across multiple sheets
See
http://www.mcgimpsey.com/excel/threedsumif.html
In article ,
Steve wrote:
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
|