Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel
- Thread starter demon147
- Start date
Wouldn't it work to sum the target cell AND the main cell? That way, when the target cell is blank, you're adding "0 + 10" then it goes on to "10 + 20" or whatever. Something like
where A2 is the cell that holds the total. ----------------------------------------
If you are reading this, then you have read too far...
lightwarrior@hotmail.com
Code:
=Sum(A1, A2)If you are reading this, then you have read too far...
lightwarrior@hotmail.com
- Status
