## RE: [Clip] Sum of a column of numbers

Expand Messages
• Hi Hugo and Steve, If the block is the only data in a column you can select it and press Ctrl+E or put an equal sign behind the last figure and press Ctrl+E.
Message 1 of 5 , Oct 10, 2002
Hi Hugo and Steve,

If the block is the only data in a column you can select it and
press Ctrl+E or put an equal sign behind the last figure and
press Ctrl+E. Likewise, you can use equations in the edit window
like (2+2)*4 (or (2+2)*4=) and use Ctrl+E. Note, if the column
is over a certain amount of lines, I think about 40, then you
will need to do a block copy and paste into a new document (if
there is other data in other columns) and use a plus sign in
between the figures. Find "^p" w/o the quotes and Replace with
"+" without the quotes. Then Ctrl+E or Block Sum.

Note: - is subtract, + is addition, * is multiply, and / is divide.

I have some Clips in my NoteBlock Library to do what you want,
perhaps cutting out some of the work. For instance, I have a
column (1st and 2nd of about ten) that has \$ in it and
oftentimes much more than 40+ lines. The Clip will add it all up
regardless of the \$, spaces, new lines (^p), more than xxx lines,
etc.

Start trying the Clips about half way down the Library at:

; Last updated on 06-28-2000

It is old code, but should still suffice. I think think work. <g>

;NoteBlock Get more Libraries at: http://www.notetab.net .
Requires NoteTab version 4.6a or above
http://www.notetab.net/zip/noteblock.zip

>Not a clip, but you can select a column (not visibly, just select
>from the beginning of the column to the end of the column a few
>lines lower) and go to Modify | Block | Sum.
>
>The result is shown in a box.

Happy Clip'n!
Jody

http://www.notetab.net

Subscribe, UnSubscribe, Options
mailto:Ntb-Clips-Subscribe@yahoogroups.com
mailto:Ntb-Clips-UnSubscribe@yahoogroups.com
http://groups.yahoo.com/group/ntb-clips
• Doesn t work for me! Maybe I misunderstood Select . Bar.
Message 2 of 5 , Oct 10, 2002
Doesn't work for me! Maybe I misunderstood 'Select'.

Bar.

> My favorite. Add an equal sign after the last number (on the same line)
> like so:
>
> 2
> 2=
>
> Select, hit CTRL + E and the sum will print after the equal sign.
>
> 2
> 2=4
>
> Pure magic!
>
> Lotta
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
• Hugo That s neat: I sort of vaguely knew it was possible, but had never actually done it. If keyboarding its: Alt+M B S ... but ... is there any non-clip way
Message 3 of 5 , Oct 10, 2002
Hugo

That's neat: I sort of vaguely knew it was possible, but had never
actually done it.

If keyboarding its: Alt+M B S ... but ... is there any non-clip way to
get that value into the clipboard so it can then be pasted into the
original document or elsewhere as required?

--
Regards ... Alec

---- Original Message ----
From: <h.paulissen@...>
To: <ntb-clips@yahoogroups.com>
Sent: 10 October, 2002 11:57
Subject: RE: [Clip] Sum of a column of numbers

> Not a clip, but you can select a column (not visibly, just select
> from the beginning of the column to the end of the column a few lines
> lower) and go to Modify | Block | Sum.
>
> The result is shown in a box.
>
> Hugo
>
>> -----Original Message-----
>> Sent: Thursday, October 10, 2002 3:18 PM
>> To: ntb-clips@yahoogroups.com
>> Subject: [Clip] Sum of a column of numbers
>>
>>
>> How do you guys obtain a sum from
>> a column of numbers?
>>
>> Anyone have a good clip?
>>
>>
>>
>> ---------------------~-->
>> Get 128 Bit SSL Encryption!
>> http://us.click.yahoo.com/JjlUgA/vN2EAA/H2RGAA/dkFolB/TM
>> --------------------------------------------------------------
>> -------~->
>>
>>
>>
>> Your use of Yahoo! Groups is subject to
>> http://docs.yahoo.com/info/terms/
>>
>>
>
> ---------------------~--> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/JjlUgA/vN2EAA/H2RGAA/dkFolB/TM
> ---------------------------------------------------------------------~
->
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
• Hi Barrie, ... Enter your figures in the document edit window, highlight the text (select), and press Ctrl and E at the same time (Ctrl+E). Actually, when
Message 4 of 5 , Oct 11, 2002
Hi Barrie,

>Doesn't work for me! Maybe I misunderstood 'Select'.

Enter your figures in the document edit window, highlight the
text (select), and press Ctrl and E at the same time (Ctrl+E).
Actually, when working with just one line, the
data does not have to be highlighted: 2*2*3 or 2*2*3=

>> My favorite. Add an equal sign after the last number (on the same line)
>> like so:
>>
>> 2
>> 2=
>>
>> Select, hit CTRL + E and the sum will print after the equal sign.
>>
>> 2
>> 2=4

Happy Clip'n!
Jody

http://www.notetab.net

Subscribe, UnSubscribe, Options
mailto:Ntb-Clips-Subscribe@yahoogroups.com
mailto:Ntb-Clips-UnSubscribe@yahoogroups.com
http://groups.yahoo.com/group/ntb-clips
Your message has been successfully submitted and would be delivered to recipients shortly.