Sorry I put C in the original e-mail but I meant E

Column A is code for that person, B is Surname, C is 1st name, D has "Total"
enterred and E is where i would need the formula/count

cheers


"Rick Rothstein" wrote:

You say your code inserts a blank row after a change in name and inserts
"Total", but your example doesn't show this. Can you post the code you are
using to do your "insert"? It will probably be easier to handle the
insertion of the COUNTA function at the same time the word "Total" is
inserted.

--
Rick (MVP - Excel)


"Adam" wrote in message
...
Hi

I've got a data dump. I've figured out how to insert a blank row after a
change in name in column A and insert "Total" - so...

bill....
bill....
bill Total -
bob....
bob....
bob....
bob Total -

What I need in column C next to total is to insert the COUNTA function for
each person.

Any ideas?

cheers



.