3d array formulas

[Idoia]

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

 

[Bob Phillips]

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

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

 

[Idoia]

Thanks a lot it's working...

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