Hello,
I have one worksheet that is referencing the second. The second sheet has a column for each date and I want to know if a value was entered today on row 8 for example. If there is not a value, I want it to return blank, but if there is, I want it to display the value in a cell that gives a total for the last 4 days.
So far I have this (in worksheet 1):
=IF(INDIRECT(" ' "&Job 1&" ' !"&ADDRESS(ROW(A8),$D$2))="","",IF(ISERROR('Job 1'!JU7),"",'Job 1'!JU7))
Where Job 1 is the name of the worksheet I'm referencing to, D2's value corresponds to correct column for today's date, and JU7 is the cell that totals the last 4 days.
What I have now returns "VALUE!"
Thanks
I have one worksheet that is referencing the second. The second sheet has a column for each date and I want to know if a value was entered today on row 8 for example. If there is not a value, I want it to return blank, but if there is, I want it to display the value in a cell that gives a total for the last 4 days.
So far I have this (in worksheet 1):
=IF(INDIRECT(" ' "&Job 1&" ' !"&ADDRESS(ROW(A8),$D$2))="","",IF(ISERROR('Job 1'!JU7),"",'Job 1'!JU7))
Where Job 1 is the name of the worksheet I'm referencing to, D2's value corresponds to correct column for today's date, and JU7 is the cell that totals the last 4 days.
What I have now returns "VALUE!"
Thanks