formulas
 

how do i find a formula that will total the number of cells in a column that
conyain data

formulas
 

=COUNTA(a1:A100)

HTH
--
AP

"tevia" a écrit dans le message de
...
how do i find a formula that will total the number of cells in a column
that
conyain data

formulas
 

One way:

=SUM(A:A)

change the column reference to suit.

In article ,
"tevia" wrote:

how do i find a formula that will total the number of cells in a column that
conyain data

formulas
 

Use the SUM feature. First click on the cell you want the data to go into.
Second click the Fx in your formula bar and either type in the data (A1:A100)
etc... Or use the mouse to "click" you data into the number 1 - number 2 -
number 3 etc...
Hopefully not confusing you,
KB


"tevia" wrote:

how do i find a formula that will total the number of cells in a column that
conyain data