Percentage Complete not totaling 100%

Darla Brown

This Month-End Checklist below has the same countif formula in both rows. January totals 100% and February only 96%. What am I missing?

This is the formula

It's counting the check boxes.

Darla Brown

Well. Not sure what happened. But it resolved itself. We are at 100% now. lol

Carson Penticuff

That does seem odd. Here are a few troubleshooting steps that may assist in determining where the problem may lie:

Use this formula to see how many items are detected as complete:

=COUNTIF(Complete48:Complete92, 1)

Then this one to see how many total items are recognized:

=COUNT(Complete48:Complete92)

If those two formulas provide different results (which they should since your result is not 100%), use this one to get a list of all tasks that are recognized as complete. Anything missing will show you which cell(s) are causing your issue:

=JOIN(COLLECT(Task48:Task92, Complete48:Complete92, 1), ", ")

Darla Brown

Hi,

That formula returned text and not a number. So cannot use it.

The first part of my formula returned 43, which is correct. The second part returned 45, which makes no sense because there are only 43 rows to count. All boxes are checked.

Carson Penticuff

Did you verify that rows 48-92 are the correct range?

The last formula would tell you which rows are missing in the count. Are you able to add a temporary column to plug the formula in there, or add it to the sheet summary?

Darla Brown

Yes. This formula is the same formula I use in 5 other sheets. This is the only one that is not working. It makes zero sense.

43 rows. 43 checkboxes. Everything is verified. Works for January. Does not work for February

Darla Brown

Well. Not sure what happened. But it resolved itself. We are at 100% now. lol