Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why doesn't this work ?
A B C
1 Fruit Qty1 Qty2 2 Apple 1 2 3 Orange 2 4 4 Apple 1 6 5 6 7 Fruit Qty1Total Qty2Total 8 Apple 9 Orange Where ... B6 is =INDEX($1:$1048576,2,2):INDEX($1:$1048576,4,2) C6 is =INDEX($1:$1048576,2,3):INDEX($1:$1048576,4,3) B8 is =SUMIF($A$2:$A$4,"Apple",$B$2:$B$4) C8 is =SUMIF($A$2:$A$4,"Apple",$C$6) B9 is =SUMIF($A$2:$A$4,"Orange",$B$2:$B$4) C9 is =SUMIF($A$2:$A$4,"Orange",$C$6) Why do the B column formulas, =SUMIF($A$2:$A$4,"Apple",$B$2:$B$4), return the correct value ... .... while the C column formulas, =SUMIF($A$2:$A$4,"Apple",$C$8), return a #VALUE error ? The reason I'm not including the C6 formula in the B column formulas as the sum_range in each SUMIF formula is to reduce the number of duplicate calculations (100,000+). Creating names for formulas like C6 works, but on row eight, there would be hundreds of these formulas requiring an equal amount of names. Is there a way to calculate formulas like C6 once and then refer to them as the SUMIF sum_range ? - Ronald K. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |