How do I sum a column where some cells contain formulae

Question

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.

adversi · Answer

Prober22&nbsp;Try an IFERROR function to the cells that give you the error. More info can be read https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611The formula would look something like this: IFERROR(B2/C2,0)

prober22 · Answer

adversi&nbsp;&nbsp;Many thanks for your help - that solved my problem.Best wishes.

Forum Discussion

How do I sum a column where some cells contain formulae

2 Replies

Resources