I need to count letter grades in range S6:S10......how many A's, B's C's etc......The students letter grades are indicated in range M2:M80
My brain is burnt...any suggestions? (not for my brain) Unsure whether to use Counta fx or Count fx
I need to count letter grades in range S6:S10......how many A's, B's C's etc......The students letter grades are indicated in range M2:M80
My brain is burnt...any suggestions? (not for my brain) Unsure whether to use Counta fx or Count fx
=countif(s$6:s$10,"a")
=countif(s$6:s$10,"a") is giving me all values of "0"
S6:S10 seems like a short enough list to count manually, so i think you want...
=countif($M$2:$M$80,S10) copied down
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
Hi,
Find the example attached. There are two ways to do this problem. The data is in Col A. Columns C and D show one method. I have also done a easy pivot table to count the grades.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks