I'm getting an error message and I don't know how o resolve it: I am trying to create a sheet to keep a track on the average working time of employees to comply with European working time: Column B has workers name Column C has gross timesheet hours Column D has other work Column E has time not working (POA) Column F has Holidays Column G has Net Column H has Cumulative hours Column I has average hours given previous weeks etc. Column G has this formula: =IF(B3>0,C3+D3-E3+F3,"") Column H has this formula: =IF($B$3>0,+G3,"") Column I has this formula =IF($B$3>0,H3/E$1,"") and then all the columns are repeated accross the next 18 weeks always adding the previous cum total. however if a worker hasn't worked for a few weeks and then you enter their hours on week 3 for instance you get value error in the cumulative cell as it is referring back to the previous cumulative week to to add it, the previous weeks cell has a formula in it, and because it it's false is left blank. I have this formula in cell V3 which is week 3 and the worker has no hours entered for week 1 & 2 and it reurns a value error until the hours are enetered into Q3 =IF(Q3>0,O3+U3,G3+N3) Is there a formula where i can tell the cumulative cell to add the last cumulative cell that has a value in it?

isnumber(), iserror()isempty(), and so on allow test in all cases.... Neither Replace ur "blank" in nor result of formula (IF(B3>0,C3+D3-E3+F3,"")by a "0". I mean if a worker was not here, u take "0" and not "blank" and don't display "o" values.

thanks taxi, I had already done that prior to you responding, I didn't update the post as I was hoping for a tidier formula as my file size is huge approx 1.4mb

Also, I have hyperlinks in Col A linking to the relevant weeks, is there anyway that I can get the hyperlink to change sheet name automatically. the cells are in the same loaction but on different sheets and I only need the hyperlink to refere to the cell on the open sheet

i think u can have a pivot table based on 18 sheets to get whole results on one, without empty results soucy