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

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
--
Max
Singapore
---
"AndyR" wrote:
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