Forum Discussion
Angela_Reinhart
Jul 16, 2021Copper Contributor
Formula for totaling a column containing formulas , but only need those cells are not blank
I am trying to sum a column which contains formulas and has returned a value; the remainder of the spreadsheet remains blank. These are the formulas in the spreadsheet. This is what it looks ...
SergeiBaklan
Jul 16, 2021Diamond Contributor
Most probably one of formulae in X9:X400 has wrong reference, thus sum of them also returns same error.