Re: Sum every Third Row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


--
Regards,

Peo Sjoblom



"Billy Liddel" <BillyLiddel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FEBE8939-7FC7-4E95-8EB3-E97B0347F9CE@xxxxxxxxxxxxxxxx
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

"Arlan" wrote:

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




.

Relevant Pages

  • Re: Sum every Third Row
    ... "Peo Sjoblom" wrote: ... Every ROW that has DIFF: ... User ID Route # Pallet Jacks Plastic Pallets Wood Pallets Blankets I/C ...
    (microsoft.public.excel.worksheet.functions)
  • Re: [TCL] diff type operations in TCL
    ... unix "sum" for a quick diff. ... if your using a unix command cmp would be better ... Bruce ...
    (comp.lang.tcl)
  • RE: Validating a resultant number against a number
    ... Is it possible that your sum looks to be say 7, ... "Pablo Fernandez" wrote: ... I have several columns where the customer will enter the amount of pallets ...
    (microsoft.public.excel.worksheet.functions)
  • Embedded Matlab Fcn and HDL Coder Data Types
    ... I want to generate HDL code. ... if (V_inj> sum) ... if (V_inj < diff) ... to introduce VHDL datatypes ...
    (comp.soft-sys.matlab)
  • RE: Validating a resultant number against a number
    ... If I have a result in the sum of the columns, it should no be greater than ... so if the customer is entering data and after enetering 30 ... pallets he wants to enter another pallet then an error messaje will let ... and I need the customer to order no more than the specified pallets ...
    (microsoft.public.excel.worksheet.functions)