Get startedGet started for free

Using COUNTIF and SUMIF

So far, we've used logical functions and intermediate techniques to create categories of data, but what if we want to aggregate data by certain categories. In chapter 1 we used PivotTables to do this, but now we'll focus on using logical aggregation functions.

COUNTIF and SUMIF are logical statements that will count or sum a specified range within a given criteria. We can use these to aggregate the data by Sales Month and gain some good insight on month-to-month trends.

If you've lost progress, open up 2_2_nesting_logical_functions.xlsx from the Workbooks folder.

This exercise is part of the course

Data Analysis in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise