View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Idoia Idoia is offline
external usenet poster
 
Posts: 29
Default 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