# Solved I'm looking to keep count of drop down menu selections

February 2, 2017 at 15:43:47
Specs: Macintosh
 In MS EXCEL I need to keep count of the number of times an item from a drop down menu is selected from a column. Tried SUMIF, but not sure I'm doing it correctly to keep a running count

See More: Im looking to keep count of drop down menu selections

#1
February 2, 2017 at 16:55:07
 What happens after the drop down value is chosen? I'm not sure what you are trying to with "SUMIF". Since we can't see your workbook from where we're siting, could you please explain your process and requirements in a little more detail? Thanks!message edited by DerbyDad03

Report •

#2
February 3, 2017 at 09:48:33
✔ Best Answer
 Just for fun....Let's say you have this layout, e.g. a Drop Down in C1 and the source list in A1:A5.``` A B C 1 Car (Drop Down Here) 2 Boat 3 Plane 4 Sled 5 Bike```Right click the sheet tab and chose View Code.Paste the following code into the pane that opensChose values from your Drop DownEach time a value is chosen, the MATCH function will return the Row in which the value is located and increment the count in the proper Row of B1:B5.```Private Sub Worksheet_Change(ByVal Target As Range) 'If Drop Down value was chosen... If Target.Address = "\$C\$1" Then 'Determine Row from source list rw = WorksheetFunction.Match(Target, Range("A1:A5")) 'Increment value in corresponding Row in Column B Range("B" & rw) = Range("B" & rw) + 1 End If End Sub```As you make your choices, you should see something like this:``` A B C 1 Car 1 (Drop Down Here) 2 Boat 3 3 Plane 4 Sled 2 5 Bike```message edited by DerbyDad03

Report •
Related Solutions