The formula you gave was perfect, thanks!
Now, I have another one.
I have a weekly total sheet that uses this formual.
=IF(SUM('Daily Lates'!L4)=0,"",SUM('Daily Lates'!L4))
However, I want to add the following to the above formula.
I want to put N/A if the sum says N/A. How can I add that to the above formula?
Thanks for all your help!!
Now, I have another one.
I have a weekly total sheet that uses this formual.
=IF(SUM('Daily Lates'!L4)=0,"",SUM('Daily Lates'!L4))
However, I want to add the following to the above formula.
I want to put N/A if the sum says N/A. How can I add that to the above formula?
Thanks for all your help!!