| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
| Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
| SORTING question | New Users to Excel | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
Threaded Mode
