Solved

Excel:  Sum if with multiple criteria

Posted on 2014-07-23
3
422 Views
Last Modified: 2014-07-23
Experts,

I have a spreadsheet that contains two columns that I need evaluated before producing the sum (population).  Here are the details:

Criteria should read:  If rows (1 - 19) in column C contains "Yes" and NOT(If rows (1 - 19) in column A contain "Digital Terminal Adapter" or "Cable Card" ) then sum all of matching criteria in Column D (population).

I have attached a file to better illustrate what I am doing.  Basically if yes in column C,  but exclude the 2 criteria in column A.

thanks!
Test-CPE-formula.xlsx
0
Comment
Question by:Maliki Hassani
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
Comment Utility
Since it appears you're using Excel 2007 or greater, you can use the SUMIFS function to solve this:
=SUMIFS(D2:D19,C2:C19,"Yes",A2:A19,"<>Digital Terminal Adapter",A2:A19,"<>Cable Card")

Reference:
http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx


Regards,
-Glenn
0
 

Author Comment

by:Maliki Hassani
Comment Utility
Thank you much!
0
 
LVL 27

Expert Comment

by:Glenn Ray
Comment Utility
You're welcome.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now