Article View: comp.apps.spreadsheets
Article #213Re: Totals by Catagories?
From: Richard Glew
Date: Fri, 06 Nov 1992 20:58
Date: Fri, 06 Nov 1992 20:58
14 lines
1103 bytes
1103 bytes
In article <92310.110359J0S@psuvm.psu.edu> J0S@psuvm.psu.edu (Jack W. Sharer) writes: >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! In Lotus I use @DSUM(INPUT,COLUMN,CRITERIA) to do this sort of work.
Technical Details
Message-ID:
<fbaglew.254@cs-acad-lan.Lakeheadu.Ca>Path:
arc1-ca.pugleaf.net!sparky!uunet!utcsri!torn!thunder!bus-rb1034.lakeheadu.ca!fbaglewReferences:
<92310.110359J0S@psuvm.psu.edu>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!utcsri!torn!thunder!bus-rb1034.lakeheadu.ca!fbaglew From: fbaglew@cs-acad-lan.Lakeheadu.Ca (Richard Glew) Newsgroups: comp.apps.spreadsheets Subject: Re: Totals by Catagories? Message-ID: <fbaglew.254@cs-acad-lan.Lakeheadu.Ca> Date: 6 Nov 1992 20:58:23 GMT References: <92310.110359J0S@psuvm.psu.edu> Sender: news@thunder.LakeheadU.Ca Organization: Lakehead University Lines: 14