We're counting parent comments from a school district survey.
We're coding each comment with the school site abbreviation, ( Jones Elementary School = JES ) and then either an A (Affirmation), C(Concern), or N(Neutral).
I understand how to get totals for the district by just using COUNTIF "A" etc., but what I'd like to do is get a count by school. If the comment is from JES, count/total A, C, N, or if the comment is from BES do not count)
Any suggestions would be greatly appreciated.
(Attached is a sample of what I'm hoping to do.)
Solved by M. D. in 29 mins