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…