Forum Discussion
Solved
Creating a Formula
Hello. I have a list of six numbers that represent the number of hours worked in each of the six days of the week (Mon thru Sat). If the employee worked all six days, I can total the column, no prob...
Phil, you are amazing!! Thank you so much...it works!! You have no idea how much time will be saved by using this calculation and I could not have come up with it if I tried from now to forever...
Gaye
In you calulation column try this. =IF(B2=0,0,IF(B3=0,SUM($B$2:B2)-SUM($C$1:C1),""))
It should do everything you were looking for. I've attached a workbook with your example.
Phil, you are amazing!! Thank you so much...it works!! You have no idea how much time will be saved by using this calculation and I could not have come up with it if I tried from now to forever...
Gaye