Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 06-10-2016, 04:00 PM   #55
ExistenceNow
AM.org Moderator
 
ExistenceNow's Avatar
 
Join Date: Aug 2004
Location: Austin, Tx
Posts: 89,676

Shows Seen: 117

DMB Hub Stubs: 30

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by BTBaboon View Post
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.
Yea, that's the plan.

Quote:
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
That looks cleaner. I like that. Thanks!
__________________
-Matthew
Dallas Tailgate Map
ExistenceNow is offline   Reply With Quote