Blank or Zero in cell required
- From: "News Account" <curious.orange@xxxxxxxxxxxx>
- Date: Fri, 15 Jul 2005 10:48:52 GMT
A B C
1 1 10 10
2 2 12 22
3 3 15 37
4 4 0 37
5 5 0 37
6 6 0 37
Hi
I hope I can explain this sufficiently well. Column A is week numbers
(1-52), column B is points gained that week, column C is the cumulative
total of points. So far so good...the problem is I would like the remaining
cells in column C to be blank or contain a zero until that week is in play.
However, when I copy the formula down the value from the last week populates
the remaining weeks. Below if the formula I'm using, this would be in C3. I
realise if I get rid of the +C2 bit it would work but then we don't have a
running total of points gained.
=SUMIF(E35,">=0",E35)+C2
Best wishes
.
- Follow-Ups:
- Re: Blank or Zero in cell required
- From: Anne Troy
- Re: Blank or Zero in cell required
- Prev by Date: Re: spreadsheet design question
- Next by Date: Re: Import Pipe Delimited File, Parse out certian Fields, create n
- Previous by thread: Cells That Appear Empty?
- Next by thread: Re: Blank or Zero in cell required
- Index(es):
Relevant Pages
|
