OK...I have what I believe is a tough one and maybe not possible. The sheet is for data tracking on assessments in a middle school. We have 4 subgroups next to their names and a conditional format based on their grade that appears in AS. I need to be able to count how many kids in the "SWD" subgroup have either red, yellow, green, or blue format...then the same for the 3 other subgroups. Ultimately I need to be able to see how many of each subgroup test in each color.
Can it be done?
IAT.jpg
You can possibly use countifs...
e.g.
=COUNTIFS(B$4:B$50,"H",$AP$4:$AP$50,">=0.70")
where B4:B50 contain the SWD flags and AP4:AP50 contain the colour coded results. This one assumes you coloured yellow for over 70%
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That ends up just counting the 2 SWD cells that have an "x" and not just the one that has an "x" and is yellow.
What is your "Yellow" conditional format formula?
value between 0.6 and 0.799 is yellow
Try:
=COUNTIFS(B$4:B$50,"x",$AP$4:$AP$50,">=0.6",$AP$4:$AP$50,"<=.799"))
adjusting ranges to suit your references
That worked...thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks