Use SUMIFS to Create Analytical Reports without PivotTables

PivotTables are one of Excel’s most powerful features – if not THE most powerful feature – and are exceptionally useful at summarizing large volumes of data when preparing analytical reports. But in some circumstances, you might need to summarize data to create an analytical report and a PivotTable may not be the ideal tool for that application. In that situation, you should consider using Excel’s SUMIFS function as an alternative and in this tip, you will learn how to take advantage of SUMIFS to create analytical reports.