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?
|