Countifs formula for checkbox column has suddenly stopped working

Christian Graf

Hello All,

My Countifs formula that counted when a box was checked in one of the columns has stopped working, giving me an invalid value error. I'm not sure if it was a recent update or what, but it has suddenly stopped working.

The Countif formula checks if the value in the checkbox column is checked:

=COUNTIFS([H1]:[H1], =[H1]@row, [Completed?]:[Completed?], =1)

The formula for the checkbox column is:

=IF(ISBLANK([Part Qty]@row), "", IF([QTY Finished Parts]@row >= [Part Qty]@row, 1, 0))

Some of the boxes are checked and some are not so I know this once is working.

Has anyone else experienced this issue?

Thanks

Paul Newcome

Is that error present in either of the referenced columns?

Paul Newcome

Is that error present in either of the referenced columns?

Christian Graf

No sir, no errors in any of the referenced columns.

Paul Newcome

Try using @cell references.

@cell = [H1]@row

@cell = 1

Christian Graf

I tried that and no luck.

Christian Graf

I made a new sheet and entered the formula, and It works in the new sheet, but not in the old one.

Its a really big sheet, with 50+ columns and almost as many column formulas. Is there a limit to how many formula you can have in one sheet?

Edit**

I found an error at the bottom of the column of one of the reference columns. Thanks!

Paul Newcome

Happy to help. 👍️

For future reference, you can create a filter to show only rows that contain # or even filter based on that specific error to help narrow things down on larger sheets.