Forum Discussion
How do I sum a column where some cells contain formulae
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 ...
Prober22 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-63f3e417f611
The formula would look something like this: IFERROR(B2/C2,0)
