I am attempting to write a formula using the countif function. The
formula needs to evaluate a list of ages and determine the quantity
meeting the range and a certain race. For example, column a has a
list of ages and column b has the letter b or w, denoting black or
white. I need to be able to analyze the list and return the number of
individuals that are between 21 and 25 and are black. I need to be
able to analyze the list for the same range of ages and white. Any
suggestions.
Don Guillett - 19 Nov 2007 16:37 GMT
=sumproduct((a2:a22>=21)*(a2:a22<25)*(b2:b22="b"))

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
>I am attempting to write a formula using the countif function. The
> formula needs to evaluate a list of ages and determine the quantity
[quoted text clipped - 4 lines]
> able to analyze the list for the same range of ages and white. Any
> suggestions.