Solved

# Sum if with two criteria

Posted on 2014-10-10
115 Views
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
Question by:cansevin
• 3

LVL 24

Expert Comment

That when you use not SUMIF, but SUMIFS.
0

LVL 24

Accepted Solution

Phillip Burton earned 500 total points
SUMIFS is SUMIFS(columntoadd, column1, criteria1, column2, criteria2...)
0

LVL 24

Expert Comment

So in this case, it's:

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

## Featured Post

### Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…