Latest Lists

In excel. I have a particular word in a drop down list that I need to count... How do I do it?

Hi, In excel I have a drop down list of Domestic and International... I want to individually count how many times Domestic is chosen and how many times International is chosen? what is the formula I use??

Public Comments

1. You could use the COUNTIF function. This function will count the records that meet specific requirements. Information on its use can be seen below. http://www.computergaga.com/excel/2007/intermediate/more_advanced_functions/countif.html
2. =COUNTIF(A:A,"Domestic") change for International