• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Quesion regarding SUMIFS vs SUMPRODUCT

S

syrianrue

New Member
so i just finished the lesson from excel school's for sumproduct. in it it says that sumproduct is used instead of sumif in their example because sumif only allows 1 criteria... hence its limitation... but isn't there why there's sumifs? which allows multiple criterias?


so instead of using sumprodut, sumifs can also be used to solve the problem in that example?

---------


also, there's really no need to use sumif instead of sumifs right? since sumifs can do everything sumif can do and more? even if we're only summing up an instance with 1 criteria?
 
Hi ,


The following link gives one very important difference between the two :


http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs


Narayan
 
Hi ,


The following link gives one very important difference between the two :


http://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs


In certain cases , even though the two can do the job , one may be better than the other , as the following link describes :


http://exceluser.com/blog/483/excels-sumifs-or-sumproduct-which-is-faster.html


This also answers your question as to why we should use SUMIF , when SUMIFS can do the same job ; even though the answer to 2^2 is the same as 2 * 2 is the same as 2 + 2 , when given the choice , we should opt for the fastest way to do the job.


Narayan
 
Two main differences between sumif, sumifs and Sumproduct

1. Sumifs is only available in Excel 2007 and later versions

2. Sumproduct accepts arrays where Sumif/s doesn't. This is useful when using Sumproduct for advanced queries
 
You must log in or register to reply here.
Back
Top