Sep 09 2019 02:12 AM
Sep 09 2019 02:27 AM
Include and error check in the formula for the total column. For example:
=IF(ISERROR(SUM(A1:C1)),"",SUM(A1:C1))
It returns an empty cell in case the sum formula would otherwise generate an error.
Sep 09 2019 03:14 AM
Sep 09 2019 04:07 AM
Sep 09 2019 04:12 AM
Sep 09 2019 04:22 AM - edited Sep 09 2019 04:25 AM
Sep 09 2019 04:22 AM - edited Sep 09 2019 04:25 AM
What error did you get?
Btw you may fix your Datedif formula to handle errors like this...
=IFERROR(DATEDIF(E2;F2;"d");0)
OR
=IFERROR(DATEDIF(E2;F2;"d");"")
You may choose one depending upon your requirement.
Sep 09 2019 04:25 AM
I think you are missing a semi-colon after F2 in the latter part of the formula.