|
|
|
|
#1
04-06-2017, 09:29 AM
|
||||
|
||||
Hi
you cannot use a condition like N7:N20="" But why not just use =SUM(N7:N20) You can hide the zero result if needed with formatting or changing Excel options
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Spell check on leaving a cell | WPeacock | Excel Programming | 0 | 02-21-2016 06:05 PM |
 Count if another cell is blank
|
caz46 | Excel | 4 | 11-02-2015 07:25 AM |
|
Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
|
not showing blank cell
|
alw | Excel | 4 | 03-13-2014 01:08 PM |
| won't show blank cell | bhum | Excel | 2 | 01-28-2014 02:34 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode