LinkBack URL
About LinkBacks
Id like to keep the cells blank if there adding 0 but pick up from the top for the first time you start to add its hard for me to explain see attachment
Id like to keep the cells blank if there adding 0 but pick up from the top for the first time you start to add its hard for me to explain see attachment
hi there, welcome to the forum. try this in C5:
=IF(D5=0,0,SUM(D$5:D5,C$4))
right-click all relevant cells & format cells -> Custom:
General;;
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi and welcome to the forum
try this, copied down...
=IF(D4="","",SUM(D$4:D4))
also, would you be able to put "Prior Week" total in G4 instead of H4?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks this works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks