[jaws-uk] Re: Excel.
- From: "Graham Page" <gpage@xxxxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Thu, 17 Jan 2008 19:38:22 -0000
if you know the range I would use the autosum formula.
this works if if you place the formula in the same column as the total you are
trying to calculate e.g. the total payment owed for a number of jobs that have
been done.
If the amounts paid were in the column C11 to C20 you could go to C22 and press
alt equals which is the short cut for Autosum. A range would be suggested
which is all the columns with numbers in above where you put the autosum
formula. Try it.
Cheers
Graham
Graham Page
Home Phone: 0207 265 9493
Mobile: 07753 607980
Fax: 0870 706 2773
Email: gpage@xxxxxxxxxxxxxx
MSN: gabriel_mcbird@xxxxxxxxxxx
Skype: gabriel_mcbird
----- Original Message -----
From: sue morgan
To: Jaws ; jaws-users-list@xxxxxxxxxxxxxx
Sent: Thursday, January 17, 2008 7:11 PM
Subject: [jaws-uk] Excel.
Hi.
I'm a bit rusty on the old spreadsheets. I did E C D L last year and I can't
remember how to calculate from say A 1 to A 10. I remember using shift down
arrow to highlight the row numbers I wanted to use in the calculation, but I've
forgotten how to work out the total in those rows.
Please could someone jog my memory. I now wish I used spreadsheets more
often because when you do something all the time, you don't forget. Never
mind, I'm sure someone on this list can help me. I think there's a quick way
of doing this calculation without typing open bracket then equals and all of
that.
Thanks.
Sue.
e-mail sue@xxxxxxxxxxxxxxxxxx
mobile 07968825286
msn sue@xxxxxxxxxxxxxxxxxx
skype suemorgan1006
__________ NOD32 2802 (20080117) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
Other related posts:
