Formula to sum blank cells

[rldjda]

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?

 

[albertmb]

Hi, I believe you are a student who needs to study a bit more. Seeking the
easy way out does not help. Try and see what you are doing wrong and you do
not find the answer come back.

 

[T. Valko]

Sum will ignore empty cells and text.

=SUM(A1:A50)

but A26:50 is blank
without having the #VALUE! in cells A26:50?

Hmmm...

That's bit confusing. I'll assume A26:A50 contain #VALUE! errors.

To get the sum of A1:A50 and ignore those errors:

=SUMIF(A1:A50,"<=1E100")