Sum every Third Row

A

Arlan

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
 
B

Billy Liddel

Arlan

Is this what you want

=SUM(IF(MOD(ROW(1:2000),3)=0,c1:c2000)). It will sum every third row in
column C. It is an array formula and must be commited with Ctrl + Shift +
Enter or it will return zero.

Regards
Peter
 
P

Peo Sjoblom

But it is not necessary if indeed the OP want to sum one column for each
"Diff" in another column?
 
B

Billy Liddel

Yes, I thought your solution would probably be correct, but the data looked
as if it might be in one column.

Regards
Peter
 
A

Arlan

Yes, I thought your solution would probably be correct, but the data looked
as if it might be in one column.

Regards
Peter





- Show quoted text -

I will check out your ideas when I get to the office...thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top