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.