help with open office

  dwhiteley 19:06 30 Apr 06
Locked

can any one help me with a stupid problem what i want to do is add a few figures

example E1 all the way to E10 can any one give me the formular to do that plus the other formular signs for add, minus, times, mutiply
thanks

  VoG II 19:10 30 Apr 06

If it is anything like Excel

=SUM(E1:E10)

Add +

Minus -

Multiply *

Divide /

  dwhiteley 19:15 30 Apr 06

i tried that but all i get is 0.00

  namtas 19:24 30 Apr 06
  dwhiteley 19:54 30 Apr 06

i have tried =sum(e4:e12) i still get a 0.00 answer

  VoG II 19:57 30 Apr 06

Do the cells actually contain numbers or are they formatterd as Text?

  dwhiteley 20:06 30 Apr 06

yes that was the problem so stupid lol

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…