Formula for weekly total, but not showing,until present month is entered.

1. Formula for weekly total, but not showing,until present month is entered.

Untitled 1.jpg

Every week, in row 3 i enter the number of boards cut. In row 9 i want a running total, but until this weeks total is entered, i dont want anything to show. This is the data for a bar chart which i print off every week.
Next week is week 3 and i will enter the data in cell d3. When i do i want cell d9 to show the new total of B3,C3,D3. And so on each week.

2. Re: Formula for weekly total, but not showing,until present month is entered.

It would be m=uch easier for us if you were to post the spread sheet itself and not a picture of it.

3. Re: Formula for weekly total, but not showing,until present month is entered.

Okay.
Table 1 is the data, 2 and 3 are the graphs.
Row3 is the weekly total. Row9 is the running total of each week. The totals in row9 so far are without a formula, i'm just getting it started, but i'd like a formula.

Thanks.

4. Re: Formula for weekly total, but not showing,until present month is entered.

Put this formule in cel B9 and copy to the right.

5. Re: Formula for weekly total, but not showing,until present month is entered.

In B9 put

=IF(B3="","",B3)

In C9, put this and drag across
=IF(C3="","",B3+C3)

6. Re: Formula for weekly total, but not showing,until present month is entered.

Excellent, and thanks for the quick replies.

Paul.

7. Re: Formula for weekly total, but not showing,until present month is entered.

You're welcome...

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1