Hi There! I am trying to create a reference sheet to pull data for a dashboard and am trying to figure out how to count instances a item with a certain value is check off. So, how many items checked off of the list are for "Property Info". I've tried using COUNTIF, COUNTIFS, COUNTM and so on, but I can't seem to figure this one out...
Is there a way to tell the formula "If an item is checked off and is tagged as 'Property Info' count it here"
I want to be able to show a quick snap shot of how much information has been received and how much is outstanding.
I did add hierarchies to maybe help keep the data accurate if lines are added...
Help Article Resources
Check out the Formula Handbook template!