Hi, JMay, thank you so much! This is exactly what I needed! :)

"JMay" wrote:

Addendum !! - When you insert new rows you will need to Copy the
Formula in Column C to the new row(s), BUT I think there is under
Tools Options a setting which if set might automatically insert the
Column C formula for you (I'll look around for it and write back)..

HTH

To eliminate the word Invoice from the formula, change it to:
=IF(A5="Invoice",COUNTIF($A$5:A5,"Invoice"),"")

Jim May


"JMay" wrote in message
:

FJ - If you mean the word "Invoice" is in column A (of your row) and you
want column C (of the same row) to increment by 1 then,
Assuming the below is range A4:C15

Enter into cell C5 and copy down:

=IF(A5="Invoice","Invoice " & COUNTIF($A$5:A5,"Invoice"),"")

MyHeader1 MyHeader2 MyHeader3 <<Row 4

Invoice Invoice 1


Invoice Invoice 2
Invoice Invoice 3

Invoice Invoice 4


Invoice Invoice 5

Give this a try and write back if problems,,

Jim May




"FJ" wrote in message
:

Hi, Pinmaster, thanks for your response. I tried the formula you suggested
but instead of numbering each cell with the word "invoice" as 1, 2, 3, etc.,
it just gave me the total count of cells with the word "invoice".


"pinmaster" wrote:

Hi,

Try:

=COUNTIF(A:A,"invoice")

HTH
Jean-Guy

"FJ" wrote:

Hi, I need to create an automatic numbering formula in Excel that will work
as follows: For every row that has the word "Invoice" in cell A1, I want
cell C1 to number automatically. There are also blank rows in the
spreadsheet, and there will be rows added and deleted from time to time. Is
there any way to write a formula to automatically number something like this,
updating the numbering when rows are added and deleted? I've tried various
"IF" and "COUNT" formulas, but to no avail. I hope I've explained this
clearly. Thanks in advance for any information. :)