Simple sheet, 5 columns. Need help please

[Aquarianguy]

Hi, I'm trying to create a simple sheet, 5 columns, Monday through Friday. You enter the value for the day into Row B. Row C cumulatively adds the days' data throughout the week.

Simple enough, but I'm trying to format it so that C2, C3, C4, C5 won't appear UNTIL a value is entered into B2, B3, B4, B5.

=IF(B2>=0, C2, 0) then formatting the text as white if it's 0, but that won't show Tuesday's cumulative number if 0 were entered.

I think I'm missing something obvious.

Any help is appreciated, and please forgive the novice-sounding question. And Thanks!

 

[jc.021286]

Hiya,

I don't quite understand what you are aiming at, I believe you mean 5 rows and not columns... though if all you want is for a tally to be kept in column C and not show if nothing is not present, then:

in C2
=if(B2>=0,sum($B$2:B2),"")

or
=if(B2>=0,C1+B2,"")

This can easily be filled down, if you want to have some 52 weeks of data, the second works better as I would hope you would have a gap for the weekends. Simply fill down,

Jc

 

[Aquarianguy]

Hi Jc, I plugged in those 2 formulas, but no change. Don't I need to combine a conditional formula like what you responded with, along with conditional formatting of the cell to turn it white IF...

That's one of the things I'm stuck on, wish I could just send the file over.
aquarianguy

 

[jc.021286]

Why use conditional formating?

Try this, as a blank cell is considered 0, we still have a problem
=IF(B2<>"",IF(A2="Monday",B2,B2+C1),"")

simply put, the above resets if in column A it comes across the word "Monday"
This prevents you getting #Value! and life continues on.

jc

 

[Aquarianguy]

Jc, this was a big winner for me:

=IF(B2<>"",IF(A2="Monday",B2,B2+C1),"")

Your help is very much appreciated!

Thanks again, really!