Hi all,

Having an issue with a formula;

I want to sum column 3 based on fulfilling criteria from 2 other columns eg

If Column A says "Product" and column B says "2024 May" then sum column Column C

It may seem simple, but having issues...




  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭

    =SUMIFS([Column C]:[Column C],[Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")

    In my example I have brackets around the column names since there is a space in the way that I have them labeled. If yours doesn't for example the name of Column A is Item, then you would use Item:Item.

    Smartsheet Community Champion and Ambassador

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Ian Cummings

    The formula should be:

    =SUMIFS([Column C]:[Column C], [Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")

    To sum the rows which fulfil the criteria.

    What issues are you having? I am guessing you have some kind of error message, can you advise what it is if so.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!