How two count values matching other values
Solved/Closed
Related:
- How two count values matching other values
- Youtube subscriber count - Guide
- If two cells match return value from third excel ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- How to count names in excel - Guide
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
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.
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.
Feb 6, 2011 at 08:05 PM
Thanks for your contribution, it was of great help. Thank you again!
Success,
Carlos