| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif across two separate columns with multiple criteria
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting with multiple criteria in separate Columns | Excel Discussion (Misc queries) | |||
| sumproduct using criteria from multiple columns in a separate wksh | Excel Worksheet Functions | |||
| COUNTIF for criteria in two separate columns (Excel 2003) | Excel Worksheet Functions | |||
| Countif using criteria in multiple columns | Excel Worksheet Functions | |||
| can countif function look at 2 separate columns for criteria | Excel Worksheet Functions | |||
![AndyR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
