Discussion How do I sum a column where some cells contain formulae in Excel
https://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060463#M85857
<P>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?</P><P>Many thanks in anticipation.</P>Thu, 14 Jan 2021 12:27:20 GMTProber222021-01-14T12:27:20ZHow do I sum a column where some cells contain formulae
https://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060463#M85857
<P>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?</P><P>Many thanks in anticipation.</P>Thu, 14 Jan 2021 12:27:20 GMThttps://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060463#M85857Prober222021-01-14T12:27:20ZRe: How do I sum a column where some cells contain formulae
https://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060594#M85859
<P><LI-USER uid="928919"></LI-USER> Try an IFERROR function to the cells that give you the error. More info can be read <A href="https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611" target="_self">here</A></P><P>The formula would look something like this: IFERROR(B2/C2,0)</P>Thu, 14 Jan 2021 12:30:19 GMThttps://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060594#M85859adversi2021-01-14T12:30:19ZRe: How do I sum a column where some cells contain formulae
https://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060691#M85862
<P><LI-USER uid="867265"></LI-USER> </P><P> </P><P>Many thanks for your help - that solved my problem.</P><P>Best wishes.</P>Thu, 14 Jan 2021 13:12:19 GMThttps://techcommunity.microsoft.com/t5/excel/how-do-i-sum-a-column-where-some-cells-contain-formulae/m-p/2060691#M85862Prober222021-01-14T13:12:19Z