🚀 go-pugleaf

------------------------- 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>