Sum challenge

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

From: "Christopher Weaver" <we.aver@xxxxxxxxxxx>
Date: Thu, 19 May 2005 14:09:25 -0700

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?

Thanks.

.

Follow-Ups:
- Re: Sum challenge
  - From: Harlan Grove
- Re: Sum challenge
  - From: JE McGimpsey

Prev by Date: Re: Is there a function that returns the sheet name?
Next by Date: RE: Formula needed: Return cell value in a range depending on other c
Previous by thread: Is there a function that returns the sheet name?
Next by thread: Re: Sum challenge
Index(es):
- Date
- Thread

Relevant Pages

Re: Sum challenge
... Christopher Weaver wrote... ... >I would like to create a formula in column A that sums the values in ... the first row in column B that is not blank. ... Prev by Date: ...
(microsoft.public.excel)
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: Yokos betrayal of John
... What does fattush do to deserve to getting flamed by ... Francie?" ... That sums it up. ... Prev by Date: ...
(rec.music.beatles)
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)