COUNTIF with mutiple ranges and multiple criteria

[aros23]

Hi, have a data set that lists people, their age and their assets (each person has somewhere from 100k to 5m). I am trying to classify them in a table based on their age and their assets within a range.

I have a series of rows with asset ranges and a series of columns with age ranges.

So the first cell should show me the number of people that have assets withing the range of 100k-250k and are ages 40 to 49.

I think I can use the COUNTIFS function but keep getting an error. Here is another way to explain what I need:

=COUNTIFS(C2:C556,">100000",C2:C556,"<250000") --> This will give me the number of people with 100k-250k in assets.

=COUNTIFS(B2:B556,">40",B2:B556,"<49") --> this will give me the number of people age 40-49.

How do I join the two together so that I only get the number of people with assets between 100-250k aged 40 to 49?

[Pepe Le Mokko]

It all depends how your data is set up. Could you please post a small sample sheet ( stripped of any confidential info)?

[judgeh59]

this seems to work...like Pepe said it assumes a few things....also, you might >= and <= depending on what you are looking for....

Please Login or Register  to view this content.

[aros23]

This did the trick! Thanks!

[judgeh59]

glad I could help and thanks for the rep points.


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

have a great day