software

I need a formula where excel would recognize an entry in say column quot;AOquot;
(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, CABGx3quot;Bmanquot; wrote:

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

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

quot;CLRquot; wrote:

gt; In cell AO1, put this formula and copy and paste it as far down column AO as
gt; you need..........
gt;
gt; =AN1 1
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;Bmanquot; wrote:
gt;
gt; gt; I need a formula where excel would recognize an entry in say column quot;AOquot;
gt; gt; (any entry) and add 1 to the number already in column AN. Something like
gt; gt; 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 Govierquot;Bmanquot; gt; wrote in message
...
gt;I need a formula where excel would recognize an entry in say column
gt;quot;AOquot;
gt; (any entry) and add 1 to the number already in column AN. Something
gt; like
gt; 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

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; Do you mean you want to count any cells with values in column AO and add
gt; that figure to a figure in cell AN1?
gt; If so =AN1 COUNTA(AO:AO)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Bmanquot; gt; wrote in message
gt; ...
gt; gt;I need a formula where excel would recognize an entry in say column
gt; gt;quot;AOquot;
gt; gt; (any entry) and add 1 to the number already in column AN. Something
gt; gt; like
gt; gt; that, I hope somebody understands what I am trying to say. Thanks
gt;
gt;
gt;

Is this what you want?

=IF(AH7=quot;quot;,quot;quot;,AH7 AN7 1)

Vaya con Dios,
Chuck, CABGx3
quot;Bmanquot; wrote:

gt; What if there is already a formula in column AO -- =IF(AH7=quot;quot;,quot;quot;,AH7) -- can
gt; I add to it to add 1 to column AN when AO is updated?
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; In cell AO1, put this formula and copy and paste it as far down column AO as
gt; gt; you need..........
gt; gt;
gt; gt; =AN1 1
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;Bmanquot; wrote:
gt; gt;
gt; gt; gt; I need a formula where excel would recognize an entry in say column quot;AOquot;
gt; gt; gt; (any entry) and add 1 to the number already in column AN. Something like
gt; gt; gt; that, I hope somebody understands what I am trying to say. Thanks

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

--
Regards

Roger Govierquot;Bmanquot; gt; wrote in message
...
gt; Actually I don't want to add the value that will be inputted but I
gt; want to
gt; add 1 to AN if anything is inputted into AO
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Do you mean you want to count any cells with values in column AO and
gt;gt; add
gt;gt; that figure to a figure in cell AN1?
gt;gt; If so =AN1 COUNTA(AO:AO)
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Bmanquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I need a formula where excel would recognize an entry in say column
gt;gt; gt;quot;AOquot;
gt;gt; gt; (any entry) and add 1 to the number already in column AN.
gt;gt; gt; Something
gt;gt; gt; like
gt;gt; gt; that, I hope somebody understands what I am trying to say. Thanks
gt;gt;
gt;gt;
gt;gt;