Summary  
This chapter covers constructing conditional aggregation formulas (SUMIFS) to dynamically sum values based on multiple criteria—such as date ranges and categories—while using an AI assistant to adjust ranges automatically.  

General domain of usage  
Financial revenue analysis in spreadsheets



Before building summaries, make sure your formulas include all data. When new rows are added, older formulas may not update automatically.

Use Copilot to adjust the ranges so all data is included and calculations remain accurate.








Ask Copilot to update your table so it references the latest data.

After the update, check that all missing values are resolved and calculated fields work correctly.

Update Formulas


Now you can build a summary based on specific conditions.

Instead of filtering manually, describe the task to Copilot. For example, calculate total revenue only for a specific sales channel and date range.

Copilot creates the formula, inserts it into a summary cell, and explains how it works

Create a Conditional Summary


Check that the summary updates correctly when data changes.

Make sure the conditions are applied as expected and the result matches your dataset.

Verify the Result

You used Copilot to combine data, handle errors, and build dynamic summaries.

You can now work with multiple datasets and generate insights without writing complex formulas manually.

Summary

Discover how to use Excel with Copilot to solve real business problems. Explore practical workflows that turn messy data into structured, reliable systems. Learn how to build models, automate calculations, and generate insights without memorizing formulas. Understand how to guide Copilot, validate its output, and keep full control over your logic.

Explore the core setup and habits for working with Copilot in Excel. You configure your environment, learn how to write clear prompts, and apply safe workflows before using Copilot on real data. You focus on testing, verifying results, and protecting your files. These skills help you avoid mistakes and use Copilot with confidence further.

Focus on turning messy, inconsistent datasets into clean and usable data. You standardize headers, split combined fields, fix mixed formats, and remove duplicates using Copilot. Consider real-world scenarios and apply structured workflows to clean data safely.

Discover using Copilot to work with clean data and turn it into insights. You extract values, connect multiple datasets, handle errors, and build dynamic summaries. Learn to describe tasks in plain language while Copilot generates and applies the formulas.

Learn how to present data in a clear and interactive way. Create PivotTables, add slicers, build charts, and apply conditional formatting to highlight key insights. Combine all elements into a structured dashboard and use Copilot to support analysis, formatting, and presentation. 

Build a forecasting model using assumptions, pricing scenarios, and 12-month projections. Test different outcomes, guide Copilot through complex logic, and turn your analysis into a clear, decision-ready recommendation.

Turn your work into a reusable, product-like spreadsheet. Clean raw data, combine multiple sources into a single system, build automated reports, and package everything into a polished template with instructions that anyone can use.

Grouped Summaries with SUMIFS