Formula

F

Fred's

I have an Excel 2000 spreadsheet used for report for any given month.
Some of the columns have text values and other number. Example:

cell range is from: cell 4 to 187

Column D Column R

Aurora 1
Chicago 2
Aurora 1


I would like to know if there is a formula that can sum how many I
have for Aurora for a cell range?


Thanking you in advance for your help!
 

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

Excel VBA 1
Figuring out a lengthy formula. Probably quite simple... 3
VLOOKUP forumla for Excel HELP! 1
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Help creating a sales commission formula 3
Excel 2013: AutoFilter and SUM() 1
Excel 2013 1
Macro that copies values from column A (from formula) to B (paste value) 1

Top