Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

Excel: Sum if with multiple criteria

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
Maliki Hassani
Asked:
Maliki Hassani
  • 2
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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
 
Maliki HassaniAuthor Commented:
Thank you much!
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now