| 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, |
|
#2
|
|||
|
|||
|
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, |
|
#3
|
|||
|
|||
|
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, |
| Reply |
| 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 | |||
Linear Mode
