rajgopal, try something like this, this is an array formula enter with
(ctrl+shift+enter)
=SUM(IF((A2:A10="east")*(B2:B10="type A"),C2:C10))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"rajgopal" wrote in message
...
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