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,
|