View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smorgan
 
Posts: n/a
Default Formula for counting multiple variables in a spreadsheet

Thanks for the response. I may have not been real clear. I am looking to
count all of instances of say "John Deere" in Column A that have the value of
"FL" in Column E.

WCoaster wrote:
The formula would be:
=COUNTIF(A4:A1000,E1)

This would count all the incidence of E1 in A1:A1000. Likewise you could
copy this formula beside every unique value in Column E.

I have a spreadsheet with multiple columns. I am trying to create a formula
that would return a count for the number of values in column A that has the

[quoted text clipped - 3 lines]

Any ideas....