How can you sum a column with blanks cells

Eric Goldsmith

I am taking the sum of a Column from another sheet but it has blank cells please help me to overcome this problem...

Maaik Meijerink

Hello Eric,

It seems a simple cross-sheet-formula could solve your problem and just ignores blank cells, such as =SUM({Sheet Range ColumnValues}), but please be more specific, as I expect this will not be the solution you are looking for ???

Grtz, Maaik

Maaik Meijerink

Hello Eric,

It seems a simple cross-sheet-formula could solve your problem and just ignores blank cells, such as =SUM({Sheet Range ColumnValues}), but please be more specific, as I expect this will not be the solution you are looking for ???

Grtz, Maaik

Eric Goldsmith

Yes sorry bit thick had the formula wrong It all works now