Then try this:

=SUM(SUMIF(A1:A5,{"x","z"},C1:C5))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"mark petrak"
wrote in message
...

i dont think thats is what i need, say cell A1 says X and Cell A2 says Y
and Cell3 says Z i want Cell H1 to look at the cells for the criteria of
either X and Z and list the Total of the corrisponding Column

A B H
1 X 1 =4 or b1 + b3
2 Y 2
3 Z 3


--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile:
http://www.excelforum.com/member.php...o&userid=26804
View this thread: http://www.excelforum.com/showthread...hreadid=512366