Is it poss to have a double array in Excel 2003?

[Guest]

HI

I am trying to use a double array. I need to use it on a pivot table result,
so I need first to check the date matches before it does the standard array
function. I can get the standard array working, but when I put in
=(IF($I$3=$A$5:$A$1200,SUM(IF(F5=$B$5:$B$34,$C$5:$C$34)),0))
it shows the grand total not just the dataq for the I3 check

 

[Bernie Deitrick]

Beads,

Your arrays need to be the same size, but this is the preferred way of doing it....

=SUMPRODUCT(($A$5:$A$1200=$I$3)*(F5=$B$5:$B$1200)*$C$5:$C$1200)

HTH,
Bernie
MS Excel MVP

 

[Guest]

Hi Beads

Have you used ctrl-shift-enter?

Have you thought of using GETPIVOTTABLE?

Regards

Phil