Birthday Chart: Need to figure something out!

Namuna

Platinum Member
Jun 20, 2000
2,435
1
0
Here's a question for you folks familiar with Excel..

You see how at the bottom of the Chart I have a running total of how many people in that column?

I'm trying to use the CountA() Function but that ONLY counts which Cell isn't empty, it doesn't actually count how many entries INSIDE the cell. Therefore I have to manually keep count (very annoying)

So, any ideas as to how I can use a Function to automatically keep a proper tally?

Thanks.
 

tomcat

Golden Member
Oct 16, 1999
1,374
0
0
I'm sorry I don't know the function you need to use, but I would like to say that I really like the site, and Go April! :)
 

hippy

Senior member
Oct 9, 1999
952
0
71


<< it doesn't actually count how many entries INSIDE the cell >>



That's because one cell is just that... &quot;one cell&quot;. Unless you give it some sort of numeric function, each cell will remain as one. Maybe you can set up what you want to do, with &quot;Access&quot;.