3d array formulas
 

Do array formulas work in multiple worksheet references?

I'm trying to sum cell C68 in every sheet where cell A27 is equal to "PD",
with the fillowing formula, entered as an array:

=+SUM(IF('PRP:HULL'!A27="PD",'PRP:HULL'!C68,0))

It's not working.

I also tried sumif, but it doesn't seem to work either:

=+SUMIF('PRP:HULL'!A27,"PD",'PRP:HULL'!C68)

Any suggestions?

Thanks

3d array formulas
 

Put the sheet names in M1:M3 (or however many) and use

=SUMPRODUCT(SUMIF(INDIRECT("'"&M1:M3&"'!A27"),"PD" ,INDIRECT("'"&M1:M3&"'!C68")))

--
__________________________________
HTH

Bob

"Idoia" wrote in message
...
Do array formulas work in multiple worksheet references?

I'm trying to sum cell C68 in every sheet where cell A27 is equal to "PD",
with the fillowing formula, entered as an array:

=+SUM(IF('PRP:HULL'!A27="PD",'PRP:HULL'!C68,0))

It's not working.

I also tried sumif, but it doesn't seem to work either:

=+SUMIF('PRP:HULL'!A27,"PD",'PRP:HULL'!C68)

Any suggestions?

Thanks

3d array formulas
 

Thanks a lot it's working...

"Bob Phillips" wrote:

Put the sheet names in M1:M3 (or however many) and use

=SUMPRODUCT(SUMIF(INDIRECT("'"&M1:M3&"'!A27"),"PD" ,INDIRECT("'"&M1:M3&"'!C68")))

--
__________________________________
HTH

Bob

"Idoia" wrote in message
...
Do array formulas work in multiple worksheet references?

I'm trying to sum cell C68 in every sheet where cell A27 is equal to "PD",
with the fillowing formula, entered as an array:

=+SUM(IF('PRP:HULL'!A27="PD",'PRP:HULL'!C68,0))

It's not working.

I also tried sumif, but it doesn't seem to work either:

=+SUMIF('PRP:HULL'!A27,"PD",'PRP:HULL'!C68)

Any suggestions?

Thanks