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
|