Hello,
I have a question about counting cell data from the same column.
Attached below is an example of the first three columns of an excel sheet I'm working on. I want to count the number of cells for each different location, i.e. count the number of; "http://en.kioskea.net/forum/forum-25-office-software?Acces=1", "http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition" and "http://en.kioskea.net/s/excel-count-lots-of-words-in-column". I realise that it is possible to create a formula to count each location separately, but is there a way to count each location type using one formula so it loops? The spreadsheet I'm working on has multiple location names and to count them one at a time would take a while.
Grateful for any help!
No.File Name Location 1 xxx http://en.kioskea.net/forum/forum-25-office-software?Acces=1 2 xxx http://en.kioskea.net/forum/forum-25-office-software?Acces=1 3 xxx http://en.kioskea.net/forum/forum-25-office-software?Acces=1 4 xxx http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition 5 xxx http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition 6 xxx http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition 7 xxx http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition 8 xxx http://en.kioskea.net/forum/affich-18257-excel-to-count-with-condition 9 xxx http://en.kioskea.net/s/excel-count-lots-of-words-in-column 10 xxx http://en.kioskea.net/s/excel-count-lots-of-words-in-column 11 xxx http://en.kioskea.net/s/excel-count-lots-of-words-in-column 12 xxx http://en.kioskea.net/s/excel-count-lots-of-words-in-column</code>Configuration: Windows XP Internet Explorer 6.0
.net get excel rows count Combine multiple rows into one column excel Excel count compare two columns same value in row Excel count if two cells same row different columns equal Excel count the number of times a value appears Excel count unique value in column 1 to sum Excel functions name sheet on cell sum('sheet1'! Excel having data entered into multiple worksheet pages Excel list multiple items unique values Excel macro dialog box file name Excel not count zeros Extract certain names from data set excel How to change the colour of font in excel sheet name How to display the same row from multiple worksheets in excel How to find multiple cells in excel Multiple if conditions in excel Using a name in an if then function excel Why can not open excel file directly when double click on file name in folder, how to solve?