Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

using excel to sum

Copper Contributor

how do I use excel to create summations with a set of input where the columns are date, person,  and price. I want to provide sub totals by month


1 Reply


Perhaps a pivot table will do what you want. See Create a pivot table in Excel