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....
|