Re: Adding numbers

Kenneth Hobson wrote:
> ...
> @SUM(B4.T10) which resolves to @SUM(B4..T10).
> 
Those of us who have been using Quattro/Lotus forever use @sum, but if 
you want to use the character that /cough! cough!/ Excel uses, you can 
use the equal sign instead: =sum(B4..T10). (This also doesn't require 
using the shift key to get the @ sign.)

You can also use the arrow keys:
* Start with @sum(
* use the arrow keys to navigate around the sheet to the top or bottom cell
* hold down the Shift key then use the arrow keys to highlight the cells 
you wish to have in your formula, then hit enter.

You can also add any non-neighboring cells, e.g. @(B2+E7)

You'll also notice as you start to type a formula (@ plus a letter), 
Quattro will offer to complete the formula for you. This can be helpful 
when you forget if the formula for *average* is /avg/ or /average/

And we won't even get into the use of the / key to access menu items, 
this is a holdover from Lotus that many of us still use :-)

Welcome aboard!

-- 

Lee

Roy's method should work fine for you.  In the case of B4 to say T10, 
(rows 4 to 10 and columns B to T):
@SUM(B4.T10) which resolves to @SUM(B4..T10).

Of course the mouse method is an easy one to help you enter the range 
while composing the formula for functions like @SUM.

If you want to enter simple and quick formulas for one row or one column 
quickly, place your cursor in the next blank cell and click the button 
to the right of the Formula Composer F(x).  If Sigma (reverse E) is 
shown, it will do a quick sum as above.  If it is not shown, select SUM 
from the drop down list.

Newbie here... how do I add the numeric values that I put in, for example, Row
4, Columns B - T using some kind of short cut formula? I'd like top do it for
many rows.

Thanks,

-- 
John

Sometimes, we give a bit more than asked so the OP and others can get 
the most out of a thread.

I think Lee meant, +B2+E7 rather than @(B2+E7).

If you want to SUM both continuous and non-continuous cells, separate 
each by a comma or semi-colon.  e.g. @SUM(B7, D7..E7)

You can also hold the control key down to select or deselect cells using 
the mouse or hot-key method to select the ranges for the formula or 
press the comma key as you select cells or ranges.

John:
> how do I add the numeric values that I put in, for example,
> Row 4, Columns B - T using some kind of short cut formula?

Newbie, indeed.-)}

In any Cell: @SUM(B4..T4)

Or, in any Cell: @SUM(
use the mouse to select the Cells
[Enter]

If your Rows are of equal length (perhaps if they are not - I 
leave you to figure this out) and largely contiguous - then put 
the @SUM() in the first Row, and with the cursor in that Cell,
Ctrl-C; select as many Cells beneath as is appropriate,
Ctrl-V.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)