Re: Sum challenge

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

Christopher Weaver wrote...
>I would like to create a formula in column A that sums the values in
column
>E starting with the row in which the formula resides and moving upward
to,
>and including, the first row in column B that is not blank. A static
range
>won't work as the number of rows above the row with the formula will
vary.
>
>Any ideas on this?

=SUM(INDIRECT("E"&MATCH(FALSE,ISBLANK(OFFSET($B$1,0,0,SUM(ROW()),1)),0)
&":E"&SUM(ROW())))

.

Relevant Pages

  • Re: Tennis Magazine: Sampras Best Ever, Navratilova 2nd, Graf 3rd, Evert-Lloyd 4th
    ... that about sums it up, though i'd say he introduced the robotic, ... mechanistic eastern-bloc athletic approach to tennis. ... one else followed suit ... ... Prev by Date: ...
    (rec.sport.tennis)
  • Re: Adding Item to ComboBox
    ... > Christopher Weaver wrote: ... >> with a ComboBox that is bound. ... > Spaces inserted to prevent google email destruction: ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Filling a 2x2 array with random numbers such that...
    ... I apologize for the mistake. ... the two sums shall be given. ... numbers for the two entries in the first row, ...
    (comp.programming)
  • Sum challenge
    ... I would like to create a formula in column A that sums the values in column ... E starting with the row in which the formula resides and moving upward to, ... A static range ... Prev by Date: ...
    (microsoft.public.excel)
  • RE: Average MTD percentage
    ... Basically this sums all values in column B that fall within the current ... and divides by the number of values that fall within the current month ... > DATE RECOVERY MTD ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)