How do I add up individual quarterly cost?

SIS

adding up quarterly cost.PNG

Uploaded Dec 22, 202144.58 KB

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

Genevieve P.

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

Genevieve P.

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

SIS

Thanks, Genevieve!