Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Strange" array formula issue
hello -
Thanks to these Groups, I've become quite proficient at using array formulas to evaluate fairly complex calculations. However, I've run into a small issue that I just cannot understand and it seems like it shouldn't be so difficult... This array formula works fine: ("week" is a Named cell) {=SUM(IF(ISERROR($M$3:$M$11000),0,$M$3:$M$11000)*( $G$3:$G$11000=($A9&week)))} This array formula DOES NOT work fine: {=SUM(IF(ISERROR($M$3:$M$11000),0,$M$3:$M$11000)*( $J$3:$J$11000="C")*($G$3:$G$11000=($A9&week)))} The difference btw the two formulas is this: ($J$3:$J$11000="C") The strange part that this formula DOES work: =COUNTIF($J$3:$J$11000,"C") Is there some fundamental difference in evaluating a range using an array formula vs the COUNTIF function? I've tried evaluating the 'bad' part of the array formula to a VALUE and to TEXT, but no change... Any ideas? TIA, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula issue with the "OR" command | Excel Worksheet Functions | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |