I am trying to make a simple timesheet, if I figure it out a little better I
will expand it, that will add over time. I just want to add up the 7 days,
cells A1-A7 and put that total in cell A9 {=SUM(A1:A7)} in cell A10 I would
like it to not do anything until columns A1-A7 go over 40, I would then like
the number 40 to stay at 40 in cell A9 then put anything over that in cell
A10{=SUMIF(A9,"40")-40} sort of like this. Is their a way to keep the
"-40" in cell A10 "invisable" until it goes over 0? And to stop the 40 in
cell A9 from going over 40? Thanks.