<div>
That when you use not SUMIF, but SUMIFS.
</div>


<div>
So in this case, it's:<br />
<br />

<pre><code id="code-20-40373023-1">=SUMIFS(C:C,A:A,D1,B:B,&quot;1&quot;)</code></pre>
</div>


So in this case, it's:



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

<div>
<div class="content wysiwyg-content">
I would like to do a sumif that has two criteria.<br />
<br />
If Column A matches the value on cell D1.<br />
If Column B has a value of &quot;1&quot;<br />
Sum the values in column C.<br />
<br />
How would this equation be? Thanks!!
</div>
</div>


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!!

Sum if with two criteria

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.