How I use SUMIF & AND
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 |
=SUMPRODUCT(--(A1:A5="east"),--(B1:B5="type A"),C1:C5) OR =SUMPRODUCT(--(A1:A5=E1),--(B1:B5=F1),C1:C5) ...where E1 contains your first criteria, and F1 contains your second. Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274667 |
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 |
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 |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com