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!


FYI: I'm a Newbie

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!