Excel: Counting an alphabetic range

[mcwinter]

Hi there
I have got a spreadsheet with a database of people and all their details, Surname (E), Name (F), Gender (L), Date of Birth (M), Age (O), etc...

So I have a demographics sheet that I calculate ages, gender etc and would like to do the following 2 tables.

1. Working out ages between 2 specified ages that I input into set cells
E.g. I want all people between the ages of 13 and 18 years old (So i put 13 into cell A13 and 18 into B13. My formula will then sit in C13 and will Also count those ages.
I want to do this so to be able to change the ages if needed

2. Working out Surnames that sit between an alphabetic range. So as I did with ages I can have "A" into A51 and "D" in B51 and it will give me all the surnames that start with those letters in a range between A and D (Including the 2 options I have in those cells)

I hope I have been clear enough. Can anyone assist? (This can be formula or VB - I am slowly learning)
Thank you!

 

[Peter_SSs]

my question is can I compare/ perform an operation with 2 arrays in a single formula with Crtl+shift +Enter method?

Yes you can compare 2 arrays, but I think the limitations will not allow you use it successfully for a question like this. When you compare 2 arrays

a) the arrays must be the same size

=SUM(--({1,2}={1,2,3})) returns #N/A


b) the comparison is between corresponding elements only

=SUM(--({1,2,4}={1,2,3})) returns 2
but
=SUM(--({2,1,3}={1,2,3})) returns only 1