Formula to find age groups

[t0v3]

Hello,

I have a column with customers ages in it. Now what I'd like to do is create a formula that checks all the age cells, then gives a percentage for each age group of my choosing. I tried some IF formulas but I just can't figure it out

Anyone help appreciated

[martindwilson]

you could use something like

Please Login or Register  to view this content.

which would give average of ages beween 20-29

[t0v3]

What that's doing is finding the average number between the ages which isn't quite what i'm after. What i'm needing is the percentage of which that age group makes up

For example

25-35 = 30%
36-45 = 40%
46 and over = 30%

[martindwilson]

oops sorry try this array confirmed with control shift and enter

Please Login or Register  to view this content.

assuming you have no zero values
count(b1:b50)could simply be replaced by the numer of rows or if you have zero values replace it with

Please Login or Register  to view this content.

still an array

[t0v3]

That works perfectly, thank you very much for your help!