Hi
use SUMPRODUCT:
=SUMPRODUCT(--(A1:A100="east"),--(B1:B100="Type A"),C1:C100)
Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany
"rajgopal" schrieb im
Newsbeitrag ...
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