Ms. Mills
unread,Jun 27, 2022, 7:42:42 AM6/27/22You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Good day,
I used excel to create report cards for my school. Each student's report card is on a different worksheet in the workbook.
I am now at the point where I need to count the number of As, Bs, Cs etc for each subject in the workbook. Is there a formula I could use to do this?
I have tried the following:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&$P$1:$P$42&"'!"&CELL("address",H11)),"A"))
P1:P42 - list of the sheet names
H11 - the cell where the letter grade appears (For example, all the English Language grades appear in H11 for each report card).
"A" - the letter grade being counted.