Counting help

Alli Parmenter

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...

Paul Newcome

You would use something along the lines of:

=COUNTIFS({Checkbox Column}, @cell = 1, {Tag Column}, @cell = "Property Info")