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.
It would be m=uch easier for us if you were to post the spread sheet itself and not a picture of it.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
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.
Last edited by paul*r; 06-07-2014 at 09:27 AM.
Put this formule in cel B9 and copy to the right.
Please Login or Register to view this content.
Last edited by popipipo; 06-07-2014 at 09:46 AM. Reason: add file
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
In B9 put
=IF(B3="","",B3)
In C9, put this and drag across
=IF(C3="","",B3+C3)
Excellent, and thanks for the quick replies.
Paul.
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks