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")


"Johnfli" wrote:

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