I can't remember how I did this...

[newman]

I have a sheet where I need the total no of entries in column C.
I have used

Text in col C =+CODE(C30) =+IF(D30>1,1)

and SUM at bottom of col E [I was not able to use COUNTA].

However when I add another entry in, say C31, D31 and E31 automatically
update although there is no formulas in these cells.

How did I manage to do that?

Regards

 

[T. Valko]

Text in col C =+CODE(C30) =+IF(D30>1,1)

Hmmm....

Can't tell what you're trying to do with that!

D31 and E31 automatically update although
there is no formulas in these cells

2 possibilities that I can think of:

There are formulas there but you have protection set and have the cells
formatted as hidden so the cells will not display the formulas they contain.

You have an event macro that updates those cells. Right click the sheet tab
and select View Code. See anything there?

--
Biff
Microsoft Excel MVP

I have a sheet where I need the total no of entries in column C.
I have used

Text in col C =+CODE(C30) =+IF(D30>1,1)

and SUM at bottom of col E [I was not able to use COUNTA].

However when I add another entry in, say C31, D31 and E31 automatically
update although there is no formulas in these cells.

How did I manage to do that?

Regards

 

[newman]

I am using CODE to check for text in the cell.

I have no hidden cells and no macros. Ctrl ¬ shows the existing formulas
and new ones appearing in col D and E as I enter text in col C.

Regards

Text in col C =+CODE(C30) =+IF(D30>1,1)

Hmmm....

Can't tell what you're trying to do with that!

D31 and E31 automatically update although
there is no formulas in these cells

2 possibilities that I can think of:

There are formulas there but you have protection set and have the cells
formatted as hidden so the cells will not display the formulas they contain.

You have an event macro that updates those cells. Right click the sheet tab

and select View Code. See anything there?

--
Biff
Microsoft Excel MVP

I have a sheet where I need the total no of entries in column C.
I have used

Text in col C =+CODE(C30) =+IF(D30>1,1)

and SUM at bottom of col E [I was not able to use COUNTA].

However when I add another entry in, say C31, D31 and E31 automatically
update although there is no formulas in these cells.

How did I manage to do that?

Regards