Sum rows if shared value in another column?

edited 12/09/19 in Formulas and Functions


I'm trying to summarize hours worked on each project for each month. My list of projects changes regularly with some coming in and some going out. Data is collected weekly so there will be multiple entries for each project. My thought was to SumIF the project identifier matches. I'm new to Smartsheet and have searched the community and haven't found a solution.

Thank you for any help you can offer!

Screenshot (10).png



  • Stefan 7k

    Hi Amy,

    yes, the SUMIF formula is the way to go.

    Based on your example an simple example would be:

    =SUMIF([Primary Column]:[Primary Column], "Pen", hours:hours)

    If you require more conditions to be met, you have to use the SUMIFS formula. Be aware though, that in SUMIFS, the column to be counted has to be named first. Example: 

    =SUMIFS(hours:hours, [Primary Column]:[Primary Column], "Pen")

    Smartsheet provides a great formula overview with live examples as a sheet in the provided templates. Search for "Smartsheet formula examples".



    Projektmanagement Professional in Frankfurt am Main, Germany

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!