SUMPRODUCT is probably best but if you want to use SUMIF you could use
this array formula.

{=SUM(IF($A$1:$A$6="AD",IF($B$1:$B$6="Jan",$C$1:$C $6,0),0))}

Commit with Ctrl-Shift-Enter which automatically puts the curly
brackets around the formula, do not type them yourself.

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=511114