You can't have AND in an array function like this, easiest would be

=SUMPRODUCT(--(A1:A20="ABC"),--(B1:B20="DEF"),C1:C20)

entered normally, if yoiu insist in using IF and entering it with ctrl +
shift & enter
use

=SUM(IF(($A$1:$A$20="ABC")*($B$1:$B$20="DEF"),$C$1 :$C$20,0))


Regards,

Peo Sjoblom

"Airfive" wrote:

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