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

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