Pivot Data with COUNTIFS and SUMIFS in Excel

Pivot Table is one of the terrific tools in Excel to summarize and report data. But it is not the only way, especially if you need a plain summary table that can be used in further calculations. Aggregation functions such as SUMIFS, COUNTIFS, and AVERAGEIFS can help in summarizing data in a pivoted layout.

Watch this video to see how COUNTIFS and SUMIFS functions can be used to summarize a list of orders by customers with different Payment Types.

COUNTIFS and SUMIFS to Pivot Data

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply