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

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

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

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


"Beads" wrote in message
...
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

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

Hi Beads

Have you used ctrl-shift-enter?

Have you thought of using GETPIVOTTABLE?

Regards

Phil


"Beads" wrote:

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