Subtotals returns TRUE in a subtotals cell

I’m trying to count how many adults there are in a given cell range. This is a column where the information “adult” or “child” (as string) is calculated with an “if” formula based on the birth date entered in another column.

The Data → Subtotals function gives me TRUE instead of the number of cells where “adult” is.

I tried with several different counts (count, counta, countif, …) but always the same result. This question has been asked before, but the answer did not help me.

Thank you.


Have you tried Right click

  • Clear Direct Formatting or
  • Format CellsNumbers tab▸Category: Number?


Hi Pierre-Yves,

I didn’t try that, but I copied the formula to another column and then back to the original column and it’s working now. I don’t understand, but as long as it works, it’s fine with me.