Totaling Instances

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of cells that share the same drop down menu. I need to totalize the number of times each item in the menu occurs in that column. The items in the dd menu are text. Any ideas? Thank

Ken Johnson
 
Are you a dd menu via Data Validation or from the Forms Toolbar. If its the latter, take a look at Data -> Validation; select "List" for the "Allow:" box and then follow Frank's advice.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function and Vlookups 2
conditional statement using validation cell 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excell 2
Updateable drop-down menu for an item database? 1
order form total 1
Total Dollar Amounts From Different Worksheet 5
Possibly an IF function? 1

Back
Top