Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria



I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A.

I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet summary I want to total up the commissions for entire sheet for each salesperson. I will have a sheet summary field for each salesperson, so there would be one formula for each salesperson.

Thanks in advance for any guidance!


  • Genevieve P.

    Hi Douglas,

    It sounds like you could use a straight-forward SUMIF formula for this!

    A SUMIF works like this:

    =SUMIF(Range, Range criterion, Sum Range)

    So in your case:

    =SUMIF([Salesperson Column]:[Salesperson Column], "Salesperson Name", [Commission Column]:[Commission Column])

    If this doesn't work for you, it would be helpful to see a screen capture of your sheet with the column names & types, etc (but please block out any sensitive data).



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!