Subtotals returns TRUE in a subtotals cell

[Andyfc]

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.

[PYS]

Hi

Have you tried Right click▸

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

Regards

[Andyfc]

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.