Countif across two separate columns with multiple criteria

A

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top