Skip to main content
Excel MIS Practice Lab

SUMIFS Practice Exercises

SUMIFS adds values that meet multiple conditions. It is one of the most-used functions in MIS and reporting work.

What does SUMIFS do?

SUMIFS sums numbers in a range when one or more conditions are true. The syntax is:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

For example, to sum sales only for the Mumbai branch and the Electronics category:

=SUMIFS(Sales[Amount], Sales[Branch], "Mumbai", Sales[Category], "Electronics")

Try it in a real exercise

Apply SUMIFS in the Daily Sales MIS Report exercise.

Open Sales Exercise

Common mistakes

  • Confusing the order of arguments: sum_range comes first in SUMIFS.
  • Criteria ranges that do not have the same size as the sum_range.
  • Forgetting to quote text criteria.