Make Excel add

[Guest]

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

 

[Guest]

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

 

[Guest]

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?

 

[Roger Govier]

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)

 

[Guest]

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

 

[Guest]

Is this what you want?

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

Vaya con Dios,
Chuck, CABGx3

 

[Roger Govier]

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