Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Pull cell format across sheets as part of the fomula? Is it poss? | Excel Worksheet Functions | |||
why doesn't Excel 2003 bottom double border icon work | Excel Discussion (Misc queries) | |||
Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |