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

Report •

#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!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

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 opens
Chose values from your Drop Down

Each 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

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •
Related Solutions


Ask Question