Nest SUM command with a command to make result cell blank

[dwest185]

Okay, I'm really new at using excel but I can do a few basic things with it. I actually have two questions. 1) I am using this formula, =SUM(B19:H19), very basic:what do I use so that my output cell is blank unless there is data in cells B19 through H19? 2) Is there a way to have a cumulative total based on data put into a cell and have the previous data stay in the output cell when the input cell is reset? For instance, I have an excel sheet that I put my daily stats in; what I want to do is make a second sheet in the workbook that will create a cumulative total of my daily stats for the year, but instead of have a seperate tick sheet for every day of the month I want to be able to delete yesterday's data from the one sheet and have the cumulative total remain the same. I hope my questions aren't too confusing...

[teylyn]

Hello,

for the first part of the question: you can wrap the sum function in an IF statement, so that it will only return a sum when there are values to sum in the target range

=IF(COUNT(B19:H19),SUM(B19:H19),"")

for the second part: yes, what you describe is possible, but only with the use of VBA. I'd strongly advise against this, because you have no audit trail or history of previous values that make up the cumulative result. This will be impossible to troubleshoot. It would be much better to keep the data that you add on a daily basis, and then perform your calculations in a separate sheet.

Upload a sample file of what you are trying to achieve, then it will be easier to give advice.

cheers,