Excel count if

[Closed]
Report
-
Posts
24
Registration date
Wednesday February 9, 2011
Status
Member
Last seen
May 30, 2012
-
Hello,

I am a school teacher that give "Marks" to students. The "marks" are leveled from 1 to 3. I have been inputting students into a spread sheet with the marks that they have. Column A: Name and Column B: 1,2, or 3.

The list in Column A: Has the names appear multiple times and Column B: has the corresponding number.

I want to have Column C to count how many 1's a student has. Column D to count how many how many 2's, and Column E to count how many 3's a student has.

I have tried a number of formulas but nothing seems to grab the two sets of data and pull them together.

thanks

Ek



2 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
Use Pivot Table for this.

Put Student Name is Row labels

Marks In column lebels

and again student name in values label
How can I do this in googlle spread sheet doc?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you use excel or it has to be google spreadsheet.
it has to be google spread sheet because it is shared with multiple teachers.
Posts
24
Registration date
Wednesday February 9, 2011
Status
Member
Last seen
May 30, 2012

Hi, you could use the autofilter feature to get unique values from column A to another column and use countif function. If you can share the Google Docs with me, I can help you. Thanks.