| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
