I need to count the number of times a numeric value appears within separate sets of data in a spreadsheet.
We're rating clinical competencies of nursing students on various things in different categories (listed in the rows) over the semester (16 weeks listed in the columns). The ratings are 0 to 4 depending how well they do.
So I need to count the # of 4's, 3's, 2's, 1's & 0's received during the 16 weeks in 8 sets of data Patient Centered Care has 2 rows of data & 16 columns, Professionalism has 8 rows of data & 16 columns, Clinical Judgment has 5 rows of data & 16 columns, and there are 5 more sets of similar data.
Is there a formula that can do this?
Solved by A. A. in 26 mins