COUNTIF formula calculating a checkbox column incorrectly
There is most likely an easy fix to my issue, but I just can't crack it myself:
I have two COUNTIFS formulas to calculate how many checkboxes are ticked and how many are unticked.
The COUNTIFS formula for the ticked checkboxes is working 100% - there are 5 check boxes ticked, which I counted manually to confirm and the formula gives = 5. However, the COUNTIFS formula for the unticked checkboxes is not counting the correct number.
In below screenshot, there are 67 rows. 5 of which, are ticked checkboxes. The COUNTIFS formula therefor needs to count 62 for the unchecked boxes, but it's calculating 72??
The Red circle on the left indicates the row number & the Red circle on the right is what the COUNTIFS formula is counting.
The Green circle on the right is the COUNTIFS formula that correctly calculates the 5 ticked checkboxes.
My two COUNTIFS formulas are below:
=COUNTIFS([X6 issue]:[X6 issue], 0) - for the unticked checkboxes
=COUNTIFS([X6 issue]:[X6 issue], 1) - for the ticked checkboxes
Help Article Resources
Check out the Formula Handbook template!