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: 3
Default Sum every Third Row

I have a spreadsheet that is created via an Access database. I am
inserting a Recordset, then inserting some blank rows after each row
of data with formulas. I now need to SUM every third row, Column C,
starting at Row 8....an example is below. Every ROW that has DIFF:
needs to be summed at the end of the spreadsheet...any ides would be
appreciated...Thanks

User ID Route # Pallet Jacks Plastic Pallets Wood Pallets Blankets I/C
Bags Straps Small Wood Comments
USSFXC 5006 1 12 0 0 2 4 0
Ret:
Diff: 1 12 0 0 2 4 0
USSEME 5008 1 10 2 0 2 6 0
Ret:
Diff: 1 10 2 0 2 6 0
USSEME 5010 1 9 0 2 1 4 0
Ret:
Diff: 1 9 0 2 1 4 0
USSJXO 5012 1 10 2 0 2 6 0
Ret:
Diff: 1 10 2 0 2 6 0
USSRMS 5014 1 4 8 0 2 6 0
Ret:
Diff: 1 4 8 0 2 6 0
USSJHZ 5016 1 10 2 0 2 5 0
Ret:
Diff: 1 10 2 0 2 5 0
USSLSD 5024 1 8 4 1 2 4 0
Ret:
Diff: 1 8 4 1 2 4 0
USSAVV 5026 1 11 1 2 0 6 0
Ret:
Diff: 1 11 1 2 0 6 0
USSAVV 5028 1 9 1 0 0 5 0
Ret:
Diff: 1 9 1 0 0 5 0
USSCME 5030 1 11 1 0 2 5 0
Ret:
Diff: 1 11 1 0 2 5 0
USSDOA 5032 1 5 7 0 1 5 0
Ret:
Diff: 1 5 7 0 1 5 0
USSDOA 5034 1 4 8 0 5 4 0
Ret:
Diff: 1 4 8 0 5 4 0
USSBHN 5036 1 8 4 0 0 4 0
Ret:
Diff: 1 8 4 0 0 4 0
USSBHN 5038 1 11 1 0 0 5 0
Ret:
Diff: 1 11 1 0 0 5 0
USSROB 5070 1 0 21 0 4 5 0
Ret:
Diff: 1 0 21 0 4 5 0
USSJXO 5105 1 8 1 0 2 5 0
Ret:
Diff: 1 8 1 0 2 5 0
USSJXO 5107 0 0 0 0 0 0 0
Ret:
Diff: 0 0 0 0 0 0 0
USSEME 5109 1 9 3 0 4 6 0
Ret:
Diff: 1 9 3 0 4 6 0
USSFXC 5111 1 5 7 0 0 4 0
Ret:
Diff: 1 5 7 0 0 4 0
USSJHZ 5113 1 7 5 0 1 5 0
Ret:
Diff: 1 7 5 0 1 5 0

 
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



All times are GMT +1. The time now is 01:20 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"