COUNTIF, one cell is text, and one cell is 'check box'
I have a summary formula that works to count a cell if there is text in it, works good, can weed out the Data that I don't want to count with other summary formulas. However there is often preplanning or left over data. My solution is to show the [route] completed [done].
=countif([route]:[route],is text(@cell)) works
But how do I combine these so the route is only counted if done is checked, so in the pic below, only the routes with the check boxed will be counted.
=IF(DONE@row, Route@row, "CANX") is being used as a helper to feed another sheet but I cant figure out how to view when there is all this happening... maybe I should just use my totals sheet?
Help Article Resources
Check out the Formula Handbook template!