Conditional age grouping

M

MarkN

I was helped with something similar a little while ago and I now have another
similar problem but this is another step up in difficulty I think.

I need to establish how many people are in 5 age bands (the last being age
not provided). However, these totals are conditional on whether the value in
column a = "text1" or "text2" but column b <> "text3". Column e lists
birthdates.
 
J

Jacob Skaria

Hi Mark again

The below will check for 'text1' and 'text2' in ColA, '<>text3' in ColC and
deduct the DOB year from current year and gives the count...

'The below check for the age group >=30 and <=35

=SUMPRODUCT((ISNUMBER(MATCH(A1:A10,{"text1","text2"},0)))*(B1:B10<>"text3")*(YEAR(TODAY())-YEAR(E1:E10)>=30)*
(YEAR(TODAY())-YEAR(E1:E10)<=35))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing a person's age to be within a range 10
retrieving multiple corresponding values with variable rows/column 4
Conditional Accounts receivable Aging Analysis 0
aging 2
Conditional Formatting 7
Calculating an age at a certain date 4
IF Multiple Conditions 2
Find variable unique text within a string 5

Top