Sum a column of numbers only if they meet certain criteria.
I hope this makes sense.
I am trying to add up all the numbers is column "Slides". But I only want to include the numbers if the done is not checked. I also not not want to include the number if column "Status" says Scoring Complete. Column "status" has many different options in it. I only need to total to be in one cell, but this sheet is forever changing so I want that cell to update on its own. Thanks for the help in advance!
Help Article Resources
Check out the Formula Handbook template!