We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Subtotals returns TRUE in a subtotals cell [closed]

asked 2016-05-11 11:23:40 +0200

Andyfc gravatar image

updated 2020-08-09 20:30:20 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-09 20:30:56.079564

1 Answer

Sort by » oldest newest most voted

answered 2016-05-11 11:36:04 +0200

pierre-yves samyn gravatar image


Have you tried Right click

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


edit flag offensive delete link more


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.

Andyfc gravatar imageAndyfc ( 2016-05-12 10:03:14 +0200 )edit

Question Tools

1 follower


Asked: 2016-05-11 11:23:40 +0200

Seen: 63 times

Last updated: May 11 '16