| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Array Help
Having a brain Fuzz.
What am I missing..The following array should return 5 if cell A1 contains ABC and cell B1 contains DEF and cell C1 contains 5. It is returning 0. Any help would be greatly appreciated. Thanks. {=SUM(IF(AND($A$1:$A$20="ABC", $B$1:$B$20="DEF"),$C$1:$C$20,0))} |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Working with array equations | Excel Discussion (Misc queries) | |||
| Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
