How two count values matching other values

carlos - Feb 5, 2011 at 09:44 AM
 Carlos - Feb 6, 2011 at 08:05 PM
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

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 response

coolcat1 Posts 12 Registration date Thursday February 3, 2011 Status Member Last seen February 7, 2011 1
Feb 5, 2011 at 02:10 PM
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.

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