Forum Discussion
excel error mean calculation with #number! in column
I am designing a database. In this database I have a column with totals that is often updated. Part of the cells of this column are filled with numbers and part with #number! were not all info is avai...
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.
Thanks! My column is based on a datedif function: DATEDIF(E2;F2;“d“). If I add the error check like in your example it looks like this: =IF(ISERROR(DATEDIF(E2;F2;“d“)),““,DATEDIF(E2;F2“d“)) . Tried this in excel but I get the reply that this does not contain enough arguments. Do you know how I can solve this? Thanks!
I think you are missing a semi-colon after F2 in the latter part of the formula.