Re: Multiple additions

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

MOD(ROW(A4,A200),4)=0 is essentially looking at every fourth row in that
range, starting at A4, and by multiplying by the range, it extracts the
values of every fourth row into an array. SUMPRODUCT sums that array. See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details.

--
HTH

Bob Phillips

"BIYB" <BIYB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:73419727-0175-44BC-973E-08A2C3E4BBC0@xxxxxxxxxxxxxxxx
> Thank you....but I dont understand the formula you suggested. Could you
give
> me the explanation?
>
> "Bernie Deitrick" wrote:
>
> > =SUMPRODUCT(A4:A200*(MOD(ROW(A4:A200),4)=0))
> >
> > --
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "BIYB" <BIYB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:3464B4AE-5EEB-4A19-AE78-0EFE7540509F@xxxxxxxxxxxxxxxx
> > >I have a workbook, where multiple forms repeat themselves 50 time or so
on
> > > the same worksheet. On one page I summarize certain information
contained in
> > > those forms. Is there an easier way then to add them one at a
> > > time....A4+A8+A12+A16+A20...etc etc (50 time over). They are all the
same
> > > amount of cells apart.
> > >
> > > Tks
> >
> >
> >


.

Relevant Pages

  • Re: ifstream::get() surprise
    ... Extracts characters and stores them into successive locations ... > null character into the next successive location of the array. ... since the rule is to post the shortest code suffering from the ...
    (comp.lang.cpp)
  • Re: how to return mulitple corresponding values
    ... "Biff" wrote: ... It's not actually multiplying numbers. ... This will return an array like this: ... If you're not using dynamic named ranges then I would "dummy down" this ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how to return mulitple corresponding values
    ... I know what the formula does but what do you mean by: sorted order i.e.the ... "Biff" wrote: ... It's not actually multiplying numbers. ... These logicals are multiplied together and result in an array of 1's ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how to return mulitple corresponding values
    ... "Biff" wrote: ... It's not actually multiplying numbers. ... This will return an array like this: ... If you're not using dynamic named ranges then I would "dummy down" this ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how to return mulitple corresponding values
    ... "Biff" wrote: ... It's not actually multiplying numbers. ... These logicals are multiplied together and result in an array of 1's or 0's ... If you're not using dynamic named ranges then I would "dummy down" this ...
    (microsoft.public.excel.worksheet.functions)