SUMIF and OR would also work for multiple conditions.


Try at the bottom of B assuming that is the column to sum if A has a 1
or a 2 in it.


{=SUM(IF(OR($A$22:$A$27=1,A22:A27=2),$B$22:$B$27,0 ))}

Change the conditions for each column to sum as needed.

Commit with Ctrl-Shift-Enter as this is an array formula.

Cheers,

Steve


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