Solved

Sum if with two criteria

Posted on 2014-10-10
3
125 Views
Last Modified: 2014-10-10
I would like to do a sumif that has two criteria.

If Column A matches the value on cell D1.
If Column B has a value of "1"
Sum the values in column C.

How would this equation be? Thanks!!
0
Comment
Question by:cansevin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40373018
That when you use not SUMIF, but SUMIFS.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40373020
SUMIF is SUMIF(column1, criteria1, columntoadd)
SUMIFS is SUMIFS(columntoadd, column1, criteria1, column2, criteria2...)
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40373023
So in this case, it's:

=SUMIFS(C:C,A:A,D1,B:B,"1")

Open in new window

0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

710 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