Range Blank
 

Good afternoon,

Is there a way to use an If statement to check to see if a range of cells is
blank? For instance, I would like to use a formula to sum B2:B10 if there is
data in at least one cell. But if all cells are blank, I would like the sum
to show a blank instead of an 0. Something like, If (B2 OR B3 OR B4...)<"",
Sum B2 to B10, Else leave blank. Any suggestions? Thanks.

Cordially,

Hi!

One way:

=IF(COUNT(B2:B10),SUM(B2:B10),"")

Biff

"Brent E" wrote in message
...
Good afternoon,

Is there a way to use an If statement to check to see if a range of cells
is
blank? For instance, I would like to use a formula to sum B2:B10 if there
is
data in at least one cell. But if all cells are blank, I would like the
sum
to show a blank instead of an 0. Something like, If (B2 OR B3 OR
B4...)<"",
Sum B2 to B10, Else leave blank. Any suggestions? Thanks.

Cordially,

Try...

=IF(COUNT(B2:B10),SUM(B2:B10),"")

Hope this helps!

In article ,
"Brent E" wrote:

Good afternoon,

Is there a way to use an If statement to check to see if a range of cells is
blank? For instance, I would like to use a formula to sum B2:B10 if there is
data in at least one cell. But if all cells are blank, I would like the sum
to show a blank instead of an 0. Something like, If (B2 OR B3 OR B4...)<"",
Sum B2 to B10, Else leave blank. Any suggestions? Thanks.

Cordially,