Addition

[nikb_mt]

I need the formula to add multiple cells together. Such as I need B10-H10 to display the total number in cell J10 in office calc

 

[Smitty]

Wouldn't that just be: =SUM(B10:H10)

HTH,

 

[nikb_mt]

I tried that, but it didn't work

 

[Smitty]

OpenOffice Calc has a SUM function, so I'm not sure what to tell you.

 

[nikb_mt]

Yeah me neither

 

[nikb_mt]

NOw it keeps setting the value to 0 when I use that formula

 

[Smitty]

Sorry, I've never used OpenOffice. Do you have values in the cells you're trying to Sum?