counting selections from a drop down list

[12thdoctor]

i am trying to count the number a drop down selections and put them in a box so i know how many i have of that selection.
so i have the column for the drop down box, so if each student has a different belt, i want to have them counted up on the belt sheet so i know how many students i have with white belts or yellow belts.



testing.xlsx

[:) Sixthsense :)]

In B2 Cell of Belts Sheet

Please Login or Register  to view this content.

Drag it down...

[dredwolf]

Sixth beat me to it

[12thdoctor]

I put the code in and the cell displays this #NAME?

[:) Sixthsense :)]

Sixth beat me to it

It is just the time when we see the post, I am sure you might have seen it later

[:) Sixthsense :)]

I put the code in and the cell displays this #NAME?

You might have misspelled the function countif

[dredwolf]

Check spelling and for extraneous spaces, formula works fine here..

@ Sixth, yep, probably why

[12thdoctor]

i copy and pasted the code

[:) Sixthsense :)]

Please share a screenshot of the error for better understanding

[dredwolf]

also,when you copy/paste, do it in the formula bar, if you do it in the cell, you sometimes get unexpected 'cell to columns' conversions

[kahlran]

Did it with "=SUM((Students!C4:C240="White")*1)" - Just put that in the cell where you want to count the belts. While adding that formula, you have to hold Ctrl+Shift, then Enter.

Copy that cell down so you have covered all belts, then change 'White' to the corresponding Belt-type.

If you want to add a larger range, change C4:C240 to whatever you need. I recommend setting it to C4:C400 or something, so you are sure you won't get a number of students which go over that.

[12thdoctor]

Thank you Sixthsense dredwolf, i figured it out, stupid me opened the file in open office, was working on a different computer, but the formula works i just had to convert it to open office. Thank you for all.

quick question, is there a way to lock the cells belt rank and testing fee to the student name, just in case i add a new student to the bottom of the list, and then sort them by last name using the sort ascending button?

[dredwolf]

WHen You do your sort, select all the columns, then do the sort, on the names column, all the adjoining cells will move with the names (IT Should do it even if you don't select the other cells, it may ask if you want to expand the selection to include the adjoining columns)

Hope this helps