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

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" <(E-Mail Removed)> wrote in message
news:EC6D1053-A4B0-4248-BAC5-(E-Mail Removed)...
> 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
>
>
>
>

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" <(E-Mail Removed)> wrote in message
> news:EC6D1053-A4B0-4248-BAC5-(E-Mail Removed)...
> > 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
> >
> >
> >
> >
>
>
>