K
Ken
We have a workbook with several hundred rows in four
columns. We imported data into the workbook. Some of the
cells have data, some have none. When we try to enter a
formula to sum columns B, C, and D, we get a "#VALUE!"
error in those rows where at least one of the cells is
blank. We assume that is because some kind of null value
is in the blank cell. If we Edit - Clear - All on the
blank cells, the formula works.
Is there a way to amend the Sum formula to ignore those
blank (null) cells?
=Sum(B11)
TIA.
columns. We imported data into the workbook. Some of the
cells have data, some have none. When we try to enter a
formula to sum columns B, C, and D, we get a "#VALUE!"
error in those rows where at least one of the cells is
blank. We assume that is because some kind of null value
is in the blank cell. If we Edit - Clear - All on the
blank cells, the formula works.
Is there a way to amend the Sum formula to ignore those
blank (null) cells?
=Sum(B11)
TIA.