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))}
|