Use a Pivot Table to Summarize Excel Data
In an earlier post, we used the SUMIFS function to create a summary table like the one on the right of this example: There, we summed the budget figures for various projects, segmenting them by status of Red, Amber, and Green (columns), and by Area (rows). We can create a similar table using a Pivot…