Hi,
I want to show in column C that how many Boys (Column A) make a cumulative %age more than 80%. For example, in Column C the values shown should be the answer
Column A: Boys Boys Boys Girls Girls Girls
Col B (***. %): 30% 70% 100% 20% 90% 100%
Column C: 3 3 3 2 2 2
Is it possible to do that?
post an excel-file, wihout confidential information.
please also add the desired result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi attached you find the file....Originally Posted by oeldere
In this file Column D is what I want. You can show it in any way but the answers should be correct.
Maybe this...
=COUNTIFS($A$2:$A$7,"Boy",$C$2:$C$7,">.85")
Change Boy to Girl
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=COUNTIFS(A2:A7,"girl",C2:C7,">85%")
i think this should help try this change boy and girls as required
=COUNTIFS(A2:A7,"girl",C2:C7,">85%")
i think this should help try this change boy and girls as required
you guys are close but thats not the answr... please see the attached file to see what exactly needs to be done...thanks!
It worked inthe sample you privided, but I think you forgot to attach the new file?
Attached you find the file again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks