Have you ever needed to quickly generate a total for a set of numbers that match one or more criteria?

If I need to add up how many hours I worked on Project123 last week, it’s not too difficult. I could probably do it in my head!

But what if I needed to calculate the cost of iPhone Pro renewals (in a company of 000’s) for 2022?

This is where knowing how to use the SUMIF and SUMIFS functions comes in useful.

In addition to explaining and demonstrating the difference between SUMIF and SUMIFS, the full tutorial video below covers the special syntax for dates, how to sum within a range of numeric values and date values (i.e. between) and how to use wildcard characters (partial matches).

Links to the video and individual sections below…


SUMIF: simple example: add up numbers that match a single criteria

SUMIF: criteria stored in a cell

SUMIF: sum of values greater than or less than a certain value

SUMIF: sum of values for a specific date

SUMIF: using wildcard characters to sum values with partial match criteria

SUMIFS: An explanation

SUMIFS: combining dates and wildcards – 2 examples