CODEWITHSUNDEEP
excel-formula
Srekk
Srekk

Reputation: 136

Sumif vs Sumifs in Excel

here is my understanding on sum functions:

Sumifs do not accept multiple columns in sum_range but Sumif do, is that correct?

if it is, could you please suggest an alternative to include multiple columns for sum range. Thanks!

Upvotes: 2

Views: 5602

Answers (1)

Henry W
Henry W

Reputation: 222

No. SUMIFS only allow a sum of one column, much like SUMIF. The difference is in the number of criteria ranges. In a SUMIFS, you would say

=SUMIFS(sum range, criteria range 1, criteria 1, criteria range 2, criteria 2, ...)

If you want to sum multiple columns, you can add multiple SUMIFSes:

=SUMIFS(...) + SUMIFS(...) + SUMIFS(...)

Upvotes: 3

Related Questions