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?

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?