Sum based on a criteria
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

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!
Help Article Resources
Categories
Check out the Formula Handbook template!