# How to count a formula?

#### philky001

##### Board Regular
In my data, I get only the date-of-birth. I made a formula to get the age- =INT((TODAY()-C276)/365) and then I

The summary data is done by the pivot table so I show all therapy service hours by age cat.
I would like to show total numbers of clients by age cat. I am not sure how to make the count to show on the pivot table or can be on the main sheet at the end.

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### DanteAmor

##### Well-known Member
Check if the following helps you.

#### philky001

##### Board Regular
Check if the following helps you.

Thank you Dante, but what is it you are doing there?

#### DanteAmor

##### Well-known Member
I am counting by category, I have 2 Adolescent, 4 adults and 3 children.

Do you need that?

Or you could show what data you have on the sheet, what you have in the pivot table and what you expect from the result.

#### philky001

##### Board Regular
I am counting by category, I have 2 Adolescent, 4 adults and 3 children.

Do you need that?

Or you could show what data you have on the sheet, what you have in the pivot table and what you expect from the result.
Yes I am having trouble doing a rows count on a column with data like child, adult, adolescent.

#### DanteAmor

##### Well-known Member
Yes I am having trouble doing a rows count on a column with data like child, adult, adolescent.
The example in the picture does not work for you?

So what data do you have and what do you want as a result?

#### philky001

##### Board Regular
The example in the picture does not work for you?

So what data do you have and what do you want as a result?
Thanks mate I worked it out thank you for your help!