How two count values matching other values

[Solved/Closed]
Report
-
 Carlos -
Hello,
I'm been trying to figure this one out. Anybody can help? Thank you!

Each student recorded both current weight and desired weight.
For students of all ages, are more men or more women above their ideal weight?
I have three columns
M N O

females actual weight ideal weight

I nee the formula to help me count the females that are above the ideal weight
I have a seperate table for males

1 reply

Posts
12
Registration date
Thursday February 3, 2011
Status
Member
Last seen
February 7, 2011
1
What you could do is add a 4th column and put a Yes in there when Actual weight is smaller or equal to ideal weight and a No when it's larger. That's a simple formula. You could even use a margin in there, saying that 5 above or 5 below ideal weight is still a Yes and everything else is a No.
That way you can also trigger the ones that are underweight.

Then count the number of females and count the number of "Yes" in the 4th column that are also female. Use that number as a percentage of the total number of females.
Do the same with the males.
coolcat1,

Thanks for your contribution, it was of great help. Thank you again!
Success,
Carlos