LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default subtotaling every third row?

Is it possible to subtotal every third row? I have the following type
of spreadsheet:

Group Style Units
B FENDI MEDIUM CHAIN BAG OH 0
B FENDI MEDIUM CHAIN BAG Sold 1
B FENDI MEDIUM CHAIN BAG Wss 0
B FENDI LARGE CHAIN BAG OH 1
B FENDI LARGE CHAIN BAG Sold 0
B FENDI LARGE CHAIN BAG WSS 0
B FENDI MEDIUM CHAIN BAG OH 1
B FENDI MEDIUM CHAIN BAG Sold 0
B FENDI MEDIUM CHAIN BAG WSS 0

Basically, I need subtotals by Group, as well as a couple of other
columns that I couldn't show in this form (this is a huuuuge
spreadsheet). I need the subtotals to add up the OH, Sold, and WSS--
Is this possible? I'm guessing it is, I'm just starting to realize
what an amazing program Excel is (once you master it)! I thought my
pivot table and V-Lookup skills were impressive, but apparently there
is a whole world of custom lists, VBA etc that I haven't even begun to
touch...Thank you soooooo much for your help, you can't even begin to
understand how much your advice will help!
Best,
Danielle

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotaling of hours Thomas Excel Worksheet Functions 2 November 28th 06 06:03 PM
Subtotaling problem noah Excel Discussion (Misc queries) 2 August 9th 05 07:27 PM
Sorting after subtotaling Katherine Excel Discussion (Misc queries) 2 January 25th 05 08:48 PM
Sorting after subtotaling Katherine Excel Worksheet Functions 1 January 25th 05 08:33 PM
Slow Subtotaling Jeremy Excel Discussion (Misc queries) 1 January 3rd 05 04:59 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"