I have a column that adds up to a total (X). In this column, some fields are blank, but need to be counted as zero, as I am getting an error that says the formula refers to empty cells. I do not want the zero to appear in the field, just have the blanks counted as zero. I tried a formula to ignore blanks, but it still gives the error. Whether it counts them as zero or ignores them, whichever provides the correct sum at the bottom.