Hello,
I am working with data analysis and I'm creating a spreadsheet. I've hit a hurdle that I need some help with. I have two functions that I want to nest together but I cannot figure it out. If it were simple I would use the countifs function but because the first function is a range I'm having trouble. Here's what I have and what I want to do:

1. Cell 1 has the result of the following function: =COUNTIF(Raw!E:E,">="&0)-COUNTIF(Raw!E:E,">"&19) ...this counts the number of cells in the raw data worksheet that has a person between the ages of 0 and 19. This works great... the answer is 1 (out of 4860 people).

2. Cell 2 has the result of the following function: =COUNTIF(Raw!I:I, "white") ...this counts the number of cells in the raw data worksheet that has a person classified as white. Again, works great... the answer is 4037 (again out of 4860).

In Cell 3 I want it to return the number of white people who are between the ages of 0-19 by combining the above functions. The answer to the above example should be 1 because there is only 1 person in this group of data who is between the ages of 0-19 and happens to be white. When I run the same function in cell 4 later for blacks, the answer should be 0. This will of course get more complicated when I try to find the number of whites who are between the ages of 60-79 because there are 2957 people in that age group. Can someone tell me how to do this? I've tried a number of things and they all return errors. I tried to add the functions together but that just gives me the sum of the them which is not what I'm looking for. I tried to nest them together but I'm doing it wrong. I'd greatly appreciate the help. Thanks!!