How can I use SUMIF & AND to calculate the values? Here is the issue:

_Column_A___Column_B____Column_C_
east Type A 10
east Type B 15
west Type A 14
west Type B 6
north Type A 12

How can I sum "east" " type A"?


--
rajgopal
------------------------------------------------------------------------
rajgopal's Profile: http://www.excelforum.com/member.php...fo&userid=7281
View this thread: http://www.excelforum.com/showthread...hreadid=274667