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.