Formula to sum blank cells
 

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?

Formula to sum blank cells
 

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.

"rldjda" wrote:

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?

Formula to sum blank cells
 

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")


--
Biff
Microsoft Excel MVP


"rldjda" wrote in message
...
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?