Search Members Help

» Welcome Guest
[ Log In :: Register ]

Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic
 

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll
Topic: Siag Spreadsheet : Any idiots guide out there?< Next Oldest | Next Newest >
timmoore46 Offline





Group: Members
Posts: 40
Joined: Feb. 2006
Posted: Feb. 08 2006,20:28 QUOTE

I'm trying to go over 98% to DSL and managed to load the data of a spreadsheet file i use daily.

That was fine, but what happened next wasn't!

With my limited intellect, I could not enter new numbers or get them to add up.

I put 1 into A1 then 2 into A2, cursored to A3 clicked on Sigma and I got 0 not 3

I'd even read a manual if I could find one which helps people like me who can't figure this out! *LOL*

Any suggestions very welcome! (Well not perhaps a bullet between the eyes!  :(   )

:)

Tim
Back to top
Profile PM 
cbagger01 Offline





Group: Members
Posts: 4264
Joined: Oct. 2003
Posted: Feb. 09 2006,04:09 QUOTE

http://siag.nu/online-docs/siag/siag.html
Back to top
Profile PM 
timmoore46 Offline





Group: Members
Posts: 40
Joined: Feb. 2006
Posted: Feb. 09 2006,09:15 QUOTE

Many thanks.  I'd read some of that already and failed to understand it.  But from your index I found 'Notes to Excel Users' and will have another go from there.

One step closer to the goal of 98% DSL!

:)

Tim
Back to top
Profile PM 
_pathos Offline





Group: Members
Posts: 91
Joined: Aug. 2005
Posted: Feb. 09 2006,09:22 QUOTE

It took 2 secs to work out :)

select the cells you want summed and then enter the cell you want the sum to go then press Sigma.

If you don't change the sum cell the last selected cell will be used and screw up because It includes itself :P
Back to top
Profile PM 
timmoore46 Offline





Group: Members
Posts: 40
Joined: Feb. 2006
Posted: Feb. 09 2006,09:47 QUOTE

Brilliant!

Thank you!

:)

Tim
Back to top
Profile PM 
4 replies since Feb. 08 2006,20:28 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

 
reply to topic new topic new poll
Quick Reply: Siag Spreadsheet : Any idiots guide out there?

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code