Marcel,
Can you give us an example using the values in A through D and show us what
you expect to see in columns E and F? I think seeing what you are trying to
get will help with a result.

Also, please tell us which cell the first formula you show is really in.
You said it is in E18, but I think that is wrong, since if it were in E18,
you'd get a circular reference error -- unless that is part of the problem
you are having. Maybe it is in E19??

"Marcel" wrote:

Good morning all!
I've run into all kind of problem with my work sheet, here they a

Rows are 15 to 21
A B C D
E F Saturday 8.00 20.00 12.00 -8.00 4.00
Sunday 8.00 20.00 12.00 -8.00 4.00
Monday 6.50 15.50 9.00 -8.00 1.00
Tuesday 11.50 20.50 9.00 -2.00 7.00
Wednesday 11.50 20.50 9.00 0.00 9.00
Thursday 11.50 20.50 9.00 0.00 9.00
Friday 11.50 20.50 9.00 0.00 9.00

the formula/function i have problem with are in Cell E15 to E 21. here's the
formu la i have in E18
(=IF(SUMIF($E$15:E18,"0",$E$15:E18)40,40-SUM($E$15:E18),-8). what i'm
trying to achieve is when ever the sum of E reach that day and the total is
40 + i need to have E18 reflex the fifference of hour ie example.

when i run into problem is when i take the saturday hours off i get this
A B C D
E F
Saturday 0.00 -8.00 -8.00
Sunday 8.00 20.00 12.00 -8.00 4.00
Monday 6.50 15.50 9.00 -8.00 1.00
Tuesday 11.50 20.50 9.00 -8.00 1.00
Wednesday 11.50 20.50 9.00 -8.00 1.00
Thursday 11.50 20.50 9.00 -8.00 1.00
Friday 11.50 20.50 9.00 -17.00 -8.00

My formulas/function in cells a
F19 -
=IF(F18-8,0,IF(SUMIF($E$15:E19,"0",$E$15:E19)40,40-SUMIF($E$15:E19,"0",$E$15:E19),-8))

F20 -
=IF(F19-8,0,IF(SUMIF($E$15:E20,"0",$E$15:E20)40,40-SUMIF($E$15:E20,"0",$E$15:E20),-8))

F21 -
=IF(F20-8,0,IF(SUMIF($E$15:E21,"0",$E$15:E21)40,40-SUMIF($E$15:E21,"0",$E$15:E21),-8))

CAN ANYONE HELP ME