Advice Request [Solved] Excel Formulas

[Deleted member 178]

ok guys,

im really a noob with excel, so i need to do this:

- create a formula that will sum (in "Total" cell) the amount in "Price" cells

then this formula will repeat for every lines under (each line been a day)

thanks

 

[CMLew]

umm.. "=D3+G3+J3+M3+P3+S3" ?

Then drag U-row to bottom.

Is that what you wanted?

 

[Deleted member 178]

umm.. "=D3+G3+J3+M3+P3+S3" ?

i did that , "Total cell" show "#value" ...

edit : omg ! this stupid Excel doesn't consider spaces between numbers ... 100000 but not 100 000...

thx @CMLew

Question solved, Thread closed.