Jan 14 2021 03:58 AM - edited Jan 14 2021 04:27 AM
I have a sheet with multiple columns containing data. In one column, Q, I have a formula that, when data is entered elsewhere within the document, the cell formula becomes a value. Not all cells are populated with values, so the "unused" cells contain "#DIV/0!" until the data is entered elsewhere. I want to be able to sum the column in Q155, but only include the cells containing values (i.e. excluding the "unused cells with formulae in). Can this be done?
Many thanks in anticipation.
Jan 14 2021 04:30 AM
Jan 14 2021 05:12 AM