Re: Totals by Catagories?

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Erich Neuwirth Tue, 10 Nov 1992 15:33

#227

Author: Erich Neuwirth
Date: Tue, 10 Nov 1992 15:33

23 lines
1670 bytes

------------------------- Original Article -------------------------
In article <92310.110359J0S@psuvm.psu.edu> J0S@psuvm.psu.edu (Jack W. Sharer) wr

>I have a spread sheet with item amounts in column G and catagories
>in column F.  I've sorted the rows using column F as the key.
>I need to have partial totals of the amounts in column G for each
>catagory in column G.  I've been entering the @SUM(G1..G13),
>@SUM(G14..G17), ... formulas by hand in the "break" rows of column
>H.  (A "break" row is one in which column F changes to a new catagory.)
>This process has become very tedious.  Could you suggest a Quattro
>MACRO which would automate this process?
>Thanks!


> n Lotus I use  @DSUM(INPUT,COLUMN,CRITERIA) to do this sort of work.

in AsEasyAs, a very good Lotus clone with some added functionality
you can do @QSUM("@X=1",range) ore something similar
which allows you to put the selection criterion into the formula
instead of putting it into a criteria range in the sheet.
you have to get the latest version to get this, it is 5.01R
and it is available from simtel and its mirrors in
<msdos.spreadsheets>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads