counting

  • Thread starter Thread starter Johnfli
  • Start date Start date
J

Johnfli

I have a spreadsheet (imagine that) that in one column, I have a list of
names., for example, D10 = John, D11= Bob, D12= Bob, D13=Frank, D14 =
John etc, etc, etc,

Then in H10= Mary, H11=Mary, H12 = Sue, H13=Mary, etc, etc, etc

Now in cell B5, I want to know teh number of time John showed up in Column D
and in B6, the number of time Bob showed up etc, etc.
In E5, I need teh same thing, but for teh names that was in column H.


The names change, so hard coding for teh names wont work. Also, if it
would be possible to have it so the total gets added up as they are typed in
without having to run a macro after teh fact would be awesome.


Thanks in advance
 
You could use the COUNTIF function for that. Put the following formula in
B5. Of course you will need the whole range in the formula. (AS in D$10 to
the end of the list.) Then copy the formula down column B and then change
the names in the formula for the ones you have copied down.

=COUNTIF(D$10:D$15,"John")
 

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

Back
Top