<div>
SUMPRODUCT adds the product of two columns or rows, whereas SUMIFS adds values where the multiple criteria (the IFS) are met. With SUMPRODUCT, the multiple criteria are the values to be multiplied before their products are added. With SUMIFS, the multiple criteria are the conditions which must be met in order for a value to be included in the sum.
</div>


SUMPRODUCT adds the product of two columns or rows, whereas SUMIFS adds values where the multiple criteria (the IFS) are met. With SUMPRODUCT, the multiple criteria are the values to be multiplied before their products are added. With SUMIFS, the multiple criteria are the conditions which must be met in order for a value to be included in the sum.

<div>
whats the difference &nbsp;- its all the same?
</div>


whats the difference  - its all the same?

<div>
can you give an example where using one might be logical than the other? situation wise....
</div>


can you give an example where using one might be logical than the other? situation wise....

<div>
Gotcha and now this makes a lot of sense<br />
<a href="http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs" rel="ugc">http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs</a>
</div>


Gotcha and now this makes a lot of sense
http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs [http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs]

<div>
The structure of SUMIFS I have used is not quite right - It should be in the form<br />
<br />
SUMIFS(RangeToSUM,Criteria<wbr />Range1,Cri<wbr />teria1, CriteriaRange2, Criteria2)<br />
<br />
You have to specify the criteria and then what the criteria value must be, e.g. SUMIFS(A1:A17,B1:B17,&quot;Fred<wbr />&quot;,C1:C17,&quot;<wbr />&lt;500&quot;) for adding values in column A where Fred is in column B and the amount in column C is less than 500.
</div>


The structure of SUMIFS I have used is not quite right - It should be in the form

SUMIFS(RangeToSUM,CriteriaRange1,Criteria1, CriteriaRange2, Criteria2)

You have to specify the criteria and then what the criteria value must be, e.g. SUMIFS(A1:A17,B1:B17,"Fred",C1:C17,"<500") for adding values in column A where Fred is in column B and the amount in column C is less than 500.

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
When I am looking at multiple criteria, sumproduct works great - -sumifs might as well?<br />
to look at multiple criteria?<br />
<br />
is one better than the other ? please explain?<br />
<br />
Rayne
</div>
</div>


Hello All,

When I am looking at multiple criteria, sumproduct works great - -sumifs might as well?
to look at multiple criteria?

is one better than the other ? please explain?

Rayne

Question

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.