Sum a column

[Alain R.]

Hi,

I don't remember how to sum a column.. What is the function ?

for exemple :
on Page1 i have G17 = 10, G50 =20, G200=50
i want do to something like SUM(Page1!$G:$G) to sum all G column and display
it on Page 2.

I don't want to use SUM because it doesn't work....
i know that exist another function with check if column cell has something
written, and add the cell content to a counter.

thanks in advance,
Alain

 

[JE McGimpsey]

What "doesn't work"?

=SUM(Page!$G:$G)

works fine to sum column G on sheet Page1.

If instead you're looking for a count of cells with values in column G,
use

=COUNTA(Page1!$G:$G)

 

[Alain R.]

I found what didn't work...formula was ok, but format what in text...so i
converted it into general...but still it didn't work.

i needed to retype all value to make it work...
EXCEL 2000 doesn't update automatically cell after changes of format

Alain

 

[JE McGimpsey]

Copy a blank cell. Select your data. Choose Edit/Paste Special,
selecting the Values and Add radio buttons. Click OK.

XL will coerce the text numbers to real numbers.