How to sum information from another sheet


Hi Actually, I have a smartsheet recovering information regarding the products manufactured during the fiscal year Periods P1to P13 (See picture 1)

I would like to sum all the products manufactured by fiscal year period on another smartsheet to regroup them like this (see picture 2)

Could you please help in how to make a formulation that can sum several lignes with a commun relation (Year fiscal period) on another smartsheet.

Thank you for your help and suggestions 

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!