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.