Auto sum with Max Totals in Cells. Please help!
Two answers in other copies of your much duplicated (courtesy of the site's
inability to decide when it really has a problem or not) request. Either
solution should work fine. Hope they work better for you than the system has
been here for the past several days.
"Anthony A." wrote:
I need help! I'm working right now and I need the cells a certain way or i'm
in big trouble. I'm supposed to have it like this:
Hours
11
regular 8
overtime 2
double t. 1
I need a formula that I just type in that 11 at the top first cell, and then
it will auto sum into the other 3 cells underneath, but a maximum of 8 hours
in the first cell, so then it will move on to 2 in the second cell but a
maximum of 2 in the second cell, so all the other hours go to double time.
Please help?
|