# Sum based on a criteria

âś­
edited 12/01/22

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"))

• âś­âś­âś­âś­âś­âś­

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

• âś­

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!

• Employee

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?