Sum based on a criteria

Options
amoncayo
amoncayo
edited 12/01/22 in Formulas and Functions

I am trying to get the sum for all of the rows in column "Total" that have a green check for paid. How can I do this?


The current formula I am trying is =SUMIFS(Total1:Total47, Paid:Paid, OR("No"))



Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @amoncayo

    It feels like something hasn't quite been explained for what you want. You say you want to get the Sum for the Total column that have a green check in the Paid column. However, then your formula has something about "Stained" and "Staining in Progress" which you haven't explained why it would be in your formula. That doesn't make sense.

    =SUMIFS(Total:Total, Paid:Paid, ="Yes")

    This would be the formula for what you said you wanted but I have a feeling there's going to be more needed lol

  • amoncayo
    Options

    My apologies I copy and pasted the wrong formula! =SUMIFS(Total1:Total47, Paid:Paid, OR("No") this is what I meant to copy that is from a previous answer that I was trying to use in my sheet!

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @amoncayo

    Did you try @Mike TV 's formula?

    Green checkmarks would be "Yes", not "No", so I would suggest trying his first. If it doesn't work, could you clarify if you're receiving an error or an incorrect result?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!