Kathy,
Try this array formula. After you type in the formula enter it b
using CtrlShiftEnter and it should look like this.

{=SUM(IF($E$1:$E$20=1,IF($I$1:$I$20=2,$A$1:$A$20), 0))}

HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=47594