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