Hi All;
I've got a weird question. I'm having trouble with a data dump; specifically summing a column. Currently my =sum(E2:E12) returns a 0 result. i.e.
Pizza 100
Wings 100
Pop 100
Sum 0
However If I manually click on each cell with a value (all of the 100's above) and press F2 enter then the sum formula works properly.
It appears to be a case of formatting, but seeing as this file is overwritten daily I'm trying to avoid having to manually refomat every day.
All thoughts are appreciated,
Derek
I've got a weird question. I'm having trouble with a data dump; specifically summing a column. Currently my =sum(E2:E12) returns a 0 result. i.e.
Pizza 100
Wings 100
Pop 100
Sum 0
However If I manually click on each cell with a value (all of the 100's above) and press F2 enter then the sum formula works properly.
It appears to be a case of formatting, but seeing as this file is overwritten daily I'm trying to avoid having to manually refomat every day.
All thoughts are appreciated,
Derek