Totals by Catagories?

Article View: comp.apps.spreadsheets

Article #208

Back to comp.apps.spreadsheets Previous Next

#208

From: Jack W. Sharer
Date: Thu, 05 Nov 1992 16:03

9 lines
815 bytes

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!

Technical Details

Message-ID: <92310.110359J0S@psuvm.psu.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!destroyer!gatech!psuvax1!psuvm!j0s

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!destroyer!gatech!psuvax1!psuvm!j0s
Organization: Penn State University
Date: Thu, 5 Nov 1992 11:03:59 EST
From: Jack W. Sharer <J0S@psuvm.psu.edu>
Message-ID: <92310.110359J0S@psuvm.psu.edu>
Newsgroups: comp.apps.spreadsheets
Subject: Totals by Catagories?
Lines: 9