How do I add up individual quarterly cost?

Hi all,
I have this datasheet with all the materials I ship. I have made columns to extract the quarter. Also, if you look at the right each row has a total cost section.
I'm trying to get all the shipped items costs to be added that fall under the same qtr. So Qtr1, Qtr2, Qtr3,Qtr4 will have a separate calculation. The cells are dynamic as I have created a form for my team to add the data whenever they ship.
Any help is appreciated!
Thanks.
FYI: I'm a Newbie
Best Answer
-
Hi @SIS
Have you looked into creating a Report from this sheet?
You can select this sheet as the Source for the Report, then Group together your Quarters (which will automatically sort all your rows in groups), and then you can use the Summarize function to SUM together the values in the Total column.
This webinar goes through the steps on how to do this: Redesigned Reports with Grouping and Summary Functions
See also:
- Configure grouping to organize results in report builder
- Summarize Content to Extract Key Information with Report Builder
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
Hi @SIS
Have you looked into creating a Report from this sheet?
You can select this sheet as the Source for the Report, then Group together your Quarters (which will automatically sort all your rows in groups), and then you can use the Summarize function to SUM together the values in the Total column.
This webinar goes through the steps on how to do this: Redesigned Reports with Grouping and Summary Functions
See also:
- Configure grouping to organize results in report builder
- Summarize Content to Extract Key Information with Report Builder
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thanks, Genevieve!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!