Quote:
Originally Posted by BTBaboon
So there's a few ways to do this, and depends on how complex you want it. Am I understanding correct that you want it to be a blank cell until you enter the daily amounts, and not show zero when you haven't entered the data?
Assuming you are only entering a date when you have worked, I'd go with an If statement.
If you have column headers in row 1, start in cell D2 and type: =if(isblank(A2),"",sum(B2:C2))
then just drag that formula down as far as you want. It will show as a blank cell until you enter the date and then will sum the amounts when enter them into columns B and C
|
If isblank statements in excel are the best