help with open office

  dwhiteley 19:06 30 Apr 2006
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 2006

If it is anything like Excel

=SUM(E1:E10)

Add +

Minus -

Multiply *

Divide /

  dwhiteley 19:15 30 Apr 2006

i tried that but all i get is 0.00

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

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

  VoG II 19:57 30 Apr 2006

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

  dwhiteley 20:06 30 Apr 2006

yes that was the problem so stupid lol

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?