Mastering SUMIFS for Accounting

In accounting, we rarely sum everything in a column. We sum based on criteria—like "Total all rows where the Account is Cash." SUMIFS is the tool for this job.

The Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, ...)

A Real-World Example

Suppose you have a general ledger in columns A through C:

DateAccountAmount
Jan 1Cash1000.00
Jan 2Inventory500.00
Jan 3Cash250.00

To find the total for Cash, your formula would be:

=SUMIFS(C2:C4, B2:B4, "Cash")

Excel looks at the range B2:B4, finds the rows that say "Cash", and adds up the corresponding values in column C (1000 + 250 = 1250).

Why use SUMIFS instead of SUMIF?

The "S" at the end of SUMIFS allows for multiple criteria. For example, you can sum only "Cash" transactions that happened in "January":

=SUMIFS(Amount, Account, "Cash", Month, "January")

We recommend always using SUMIFS (even for one criterion) because it keeps your logic consistent and expandable.

Common Mistakes

Ready to try it? Practice ledger totaling here.