I need a formula to sum A1:50 even if there are blank cells within that
range.
For example, A1:25 has numeric data , but A26:50 is blank. I want A:51 to
sum the entire range of A1:50. How can I do this without having the #VALUE!
in cells A26:50?