Quote:
Originally Posted by ExistenceNow
I am virtually illiterate when it comes to Excel, so if someone could help me with some basic shit, I would really appreciate it.
I'm working for two companies right now. Each day I make money from each. So I have a column for each one where I enter my earnings for that day. I want to have a Daily Total column where it adds up the two numbers each day. Is there a way to put a formula over the whole DT column so that it automatically generates those numbers every day as I enter the two separate company totals?
So Date in Column A. Column B for Company B. Column C for Company C. Column D for Daily total. Column D fills in automatically as the numbers get entered into B and C.
Does that make sense?
|
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