I need a formula where excel would recognize an entry in say column "AO"
(any entry) and add 1 to the number already in column AN. Something like
that, I hope somebody understands what I am trying to say. Thanks

In cell AO1, put this formula and copy and paste it as far down column AO as
you need..........

=AN1+1

Vaya con Dios,
Chuck, CABGx3


"Bman" wrote:

I need a formula where excel would recognize an entry in say column "AO"
(any entry) and add 1 to the number already in column AN. Something like
that, I hope somebody understands what I am trying to say. Thanks

What if there is already a formula in column AO -- =IF(AH7="","",AH7) -- can
I add to it to add 1 to column AN when AO is updated?

"CLR" wrote:

In cell AO1, put this formula and copy and paste it as far down column AO as
you need..........

=AN1+1

Vaya con Dios,
Chuck, CABGx3


"Bman" wrote:

I need a formula where excel would recognize an entry in say column "AO"
(any entry) and add 1 to the number already in column AN. Something like
that, I hope somebody understands what I am trying to say. Thanks

Is this what you want?

=IF(AH7="","",AH7+AN7+1)

Vaya con Dios,
Chuck, CABGx3



"Bman" wrote:

What if there is already a formula in column AO -- =IF(AH7="","",AH7) -- can
I add to it to add 1 to column AN when AO is updated?

"CLR" wrote:

In cell AO1, put this formula and copy and paste it as far down column AO as
you need..........

=AN1+1

Vaya con Dios,
Chuck, CABGx3


"Bman" wrote:

I need a formula where excel would recognize an entry in say column "AO"
(any entry) and add 1 to the number already in column AN. Something like
that, I hope somebody understands what I am trying to say. Thanks

Hi

Do you mean you want to count any cells with values in column AO and add
that figure to a figure in cell AN1?
If so =AN1+COUNTA(AO:AO)

--
Regards

Roger Govier


"Bman" wrote in message
...
I need a formula where excel would recognize an entry in say column
"AO"
(any entry) and add 1 to the number already in column AN. Something
like
that, I hope somebody understands what I am trying to say. Thanks

Actually I don't want to add the value that will be inputted but I want to
add 1 to AN if anything is inputted into AO

"Roger Govier" wrote:

Hi

Do you mean you want to count any cells with values in column AO and add
that figure to a figure in cell AN1?
If so =AN1+COUNTA(AO:AO)

--
Regards

Roger Govier


"Bman" wrote in message
...
I need a formula where excel would recognize an entry in say column
"AO"
(any entry) and add 1 to the number already in column AN. Something
like
that, I hope somebody understands what I am trying to say. Thanks

Hi
Then maybe
=AN1+1*COUNTA(AO:AO)0

--
Regards

Roger Govier


"Bman" wrote in message
...
Actually I don't want to add the value that will be inputted but I
want to
add 1 to AN if anything is inputted into AO

"Roger Govier" wrote:

Hi

Do you mean you want to count any cells with values in column AO and
add
that figure to a figure in cell AN1?
If so =AN1+COUNTA(AO:AO)

--
Regards

Roger Govier


"Bman" wrote in message
...
I need a formula where excel would recognize an entry in say column
"AO"
(any entry) and add 1 to the number already in column AN.
Something
like
that, I hope somebody understands what I am trying to say. Thanks