Incorrect counting of blank rows

Angela Ryer

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNT([Completed Tasks]:[Completed Tasks], IF([Task Name]:[Task Name], ""))

I have a checkbox column that will read in the summary bar (row 1) when working "Completed 6 of 33" However, it is counting blank rows and should read "Completed 6 of 25"

The formula is in the checkbox column, and I attempted to have it reference the Task Name column, if blank then don't count. but i can't get it working. Please help!

Paul Newcome

My apologies. Try this...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

Paul Newcome

Give this a go...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1))

Angela Ryer

It still counts empty rows.

This should be more like 2 of 25 but is counting the entire column even if the row is blank. (Which is why i tried to use [Task Name] to only count if not blank. But i'm happy to do it any avenue that gets it working.

Any other suggestions?

Paul Newcome

My apologies. Try this...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

Angela Ryer

awww, yes! thank you!!

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

Paul Newcome

Happy to help! 👍️