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!

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?
Join us at Smartsheet ENGAGE 2024 đźŽ‰
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!