Totals by Catagories?

Thread View: comp.apps.spreadsheets

2 messages

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

2 total messages Started by Jack W. Sharer Thu, 05 Nov 1992 16:03

#208

Author: 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!

Re: Totals by Catagories?

#213

Author: Richard Glew
Date: Fri, 06 Nov 1992 20:58

14 lines
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.

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