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

C

Cindy

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?
 
R

Ron Rosenfeld

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
 
Top