Make Excel add

B

Bman

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
 
C

CLR

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
 
B

Bman

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?
 
R

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

Bman

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
 
Top