Previous Topic Next Topic

Excel count if

Closed
edonkatz - Feb 28, 2011 at 06:28 PM
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - Mar 5, 2011 at 01:25 AM
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



Related:

2 responses

Answer 1 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 1, 2011 at 05:31 AM
Use Pivot Table for this.

Put Student Name is Row labels

Marks In column lebels

and again student name in values label
ekatz
Mar 1, 2011 at 06:56 AM
How can I do this in googlle spread sheet doc?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2011 at 05:31 PM
could you use excel or it has to be google spreadsheet.
ekatz
Mar 5, 2011 at 12:30 AM
it has to be google spread sheet because it is shared with multiple teachers.
Answer 2 / 2
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012
Mar 5, 2011 at 01:25 AM
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.

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses