Countif across two separate columns with multiple criteria

[AndyR]

Hi,
I'm trying to count across two columns with the aim of being able to say all
children aged 5-7 rated this a 1, all children aged 3-4 rated this 2, etc.
Below is an example of the data I'm working with:
Col W Col X Col Y
Age Score
3 2 3
4 1 3
4 1 4
5 2 4
2 1 4
5 2 4
7 2 4


So I'm interested in finding out how many 3-4 year olds in Col W scored 1 in
Col y.

Can anyone help?!!
Andy

 

[Max]

To do this count ..

.. how many 3-4 year olds in Col W scored 1 in Col y

use something like this:
=SUMPRODUCT((W2:W10>=3)*(W2:W10<=4)*(Y2:Y10=1))

This part of it: (W2:W10>=3)*(W2:W10<=4)
shows a more generic way to grab the desired age range in col W (albeit your
age range happened to be the minimum in this instance, only 2 ages)
Inspiring? hit the YES below