Should I be using "IF"

[Danno]

I have one column that I enter weekly numbers in (i.e. Column "E", Rows 1 thru 52). I have another column (i.e. "H" also using Rows 1 thru 52) that I want to have excel total all the numbers up, to give me a "Year to Date" total entered so far. If I've entered values up to week 8 (i.e Column "E" I have numbers entered in Rows 1 thru 8), I want the YTD column to show me the total (i.e. Column "H" Row 8 will show me that total of Column "E" Rows 1 thru 8). I can do that easily. What I'm having trouble with is that I want all rows, in the YTD column to show 'zeros' below the row that has the last entry. There must be a formula to do this (i.e. IF(E9=0,0) @SUME1,E9). Any Help would be appreciated.

 

[RagDyer]

If I understand you, try this:

In H1 enter:
=E1

In H2 enter:
=(E2>0)*(E2+H1)

And drag down to copy.

However, if you should happen to skip a week, or have zero numbers for a
week, this formula will start over from the zero week and give inaccurate
YTD totals.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have one column that I enter weekly numbers in (i.e. Column "E", Rows 1
thru 52). I have another column (i.e. "H" also using Rows 1 thru 52) that I
want to have excel total all the numbers up, to give me a "Year to Date"
total
entered so far. If I've entered values up to week 8 (i.e Column "E" I have
numbers entered in Rows 1 thru 8), I want the YTD column to show me the
total (i.e. Column "H" Row 8 will show me that total of Column "E" Rows 1
thru 8). I can do that easily. What I'm having trouble with is that I want
all rows, in the YTD column to show 'zeros' below the row that has the last
entry. There must be a formula to do this (i.e. IF(E9=0,0) @SUME1,E9). Any
Help would be appreciated.

 

[RagDyer]

This formula will give you a grace period of one week of 0.
It will however, extend the YTD total one week beyond the last entry.

=(OR(E1>0,E2>0)*(E2+H1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I understand you, try this:

In H1 enter:
=E1

In H2 enter:
=(E2>0)*(E2+H1)

And drag down to copy.

However, if you should happen to skip a week, or have zero numbers for a
week, this formula will start over from the zero week and give inaccurate
YTD totals.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have one column that I enter weekly numbers in (i.e. Column "E", Rows 1
thru 52). I have another column (i.e. "H" also using Rows 1 thru 52) that I
want to have excel total all the numbers up, to give me a "Year to Date"
total
entered so far. If I've entered values up to week 8 (i.e Column "E" I have
numbers entered in Rows 1 thru 8), I want the YTD column to show me the
total (i.e. Column "H" Row 8 will show me that total of Column "E" Rows 1
thru 8). I can do that easily. What I'm having trouble with is that I want
all rows, in the YTD column to show 'zeros' below the row that has the last
entry. There must be a formula to do this (i.e. IF(E9=0,0) @SUME1,E9). Any
Help would be appreciated.

 

[Danno]

RagDyer

Worked like a charm. Probably looked like a dumb question. Thanx for the help.

Danno