SOLVED what's missing. one row works; none of others do.

[dbrhlngls]

I don't understand how why row 8 in worksheet 2020 is working and none of the others in that worksheet or any of the others aren't. I have rechecked my formulas...they all look okay.
thanks
Debbie

[63falcondude]

Hi Debbie, welcome to the forum.

When you say that the rows "aren't working", what do you mean by this?

I see that there are #VALUE! errors in column V. This happens whenever column T is blank.

Column T is blank whenever column L is "Late".

What do you expect to see that you aren't currently seeing?

[Pete_UK]

You could avoid the #VALUE errors by changing the formula in V8 to this:

=IF(Q8>T8,"",SUM(T8,-Q8))

though that will show you negative values if T8 is blank. You can intercept the errors by doing this in V8:

=IFERROR(IF(Q8>T8,"",T8-Q8),"")

which will return a blank instead.

Hope this helps.

Pete

[dbrhlngls]

so when i change date in S8 the numbers change correctly in T8/V8 depending on what number I put in Q8. I want the info to change in the other rows the same way.
debbie

[Gregb11]

I believe they do when you change the status from "Late" to something else (like "Complete")

[dbrhlngls]

thanks everyone.....it worked based on your suggestions...I am so new at Excel it's embarrassing to realize what I was missing was so simple