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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
