Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
Sum or Sumif | Excel Discussion (Misc queries) | |||
How Do I created a nested sumif - if this column has this and thi. | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |