How to count a formula?

[philky001]

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
make an age category: =IF(D2<12,"Child",IF(D2<18,"Adolescent","Adult"))

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.

 

[DanteAmor]

Check if the following helps you.

 

[philky001]

Check if the following helps you.

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

 

[DanteAmor]

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]

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]

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]

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!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.