Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting data in multiple columns
Hello,
i have survey results which show male, female, distance walked etc. in separate columns I want to analyse how many females, walk 30km females walk 50km males walk 30km etc etc what's the best way of doing this? - countif ...??? and how do i do it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting data in multiple columns
I am assuming you may want to know how many females walked 30 or more km, but
less than 50 (versus how many walked exactly 30 km). try: =Sumproduct(--(A1:A10="female"), --(B1:B10=30), --(B1:B10<50)) if my assumption is wrong and you have trouble w/getting it to work, post back. of course, you can replace "female", 30, and 50 with cell references instead of hardcoding the criteria into the formula. "Lisa" wrote: Hello, i have survey results which show male, female, distance walked etc. in separate columns I want to analyse how many females, walk 30km females walk 50km males walk 30km etc etc what's the best way of doing this? - countif ...??? and how do i do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting text across multiple columns | Excel Worksheet Functions | |||
Counting rows from columns on multiple worksheets? | Excel Worksheet Functions | |||
Counting from multiple columns | Excel Discussion (Misc queries) | |||
Counting rows based on multiple columns | Excel Worksheet Functions | |||
Counting values in multiple columns | Excel Discussion (Misc queries) |