Totaling how many times a specific word is listed in a spreadsheet

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

Guest

I have a very large spreadsheet that list various projects completed and the county in which it was completed for. I need a the total number of projects completed for each county which is always changing. How can I get a total without manually counting?
 
I have a very large spreadsheet that list various projects completed and the county in which it was completed for. I need a the total number of projects completed for each county which is always changing. How can I get a total without manually counting?
Click to expand...

Either use a pivot table, or use a formula of the type:

=SUMPRODUCT((COUNTY=county)*(PROJECT=complete))


--ron
 

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 - counting cells by colors and names to it in two different rows. 0
Check Spreadsheet entries against a list 1
Inserting rows using a list of numbers 3
how to carry forward a total from one page to another 3
Pivot tables - counting unique numbers 2
Counting number of items excluding duplicates. 1
Locating Source Data in Master Spreadsheet 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top