sumif across multiple sheets
The sheet names are not Sheet1, Sheet2, Sheet3 etc... I just put in for
simplicity. They can be any name.
Thanks.
"Biff" wrote:
If your sheet names really are Sheet1, Sheet2, Sheet3 etc:
=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1 :9"))&"!B1"),"PMI",INDIRECT("Sheet"&ROW(INDIRECT(" 1:9"))&"!A3")))
Biff
"Bob Phillips" wrote in message
...
Try putting the sheet names in C1:c9 and use
=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C9&"'!B1"),"PMI" ,INDIRECT("'"&C1:C9&"'!A3"
)))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Steve" wrote in message
...
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
|