|
|
#1
04-06-2017, 08:07 AM
|
|||
|
|||
leaving cell blank
I am building a time card.
what i want to do in cell n22 is add the entries in cells n7:n20, but leave n22 blank if there is nothin in those cells. Tried =IF(N7:N20="","",SUM(N7:N20)) but get a value error. Am I going at this wrong? Any help would be appreciated. I think I have attached the file so maybe it will make more since. Thanks, Jerry. 
|
|
|
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 32bit 
Office 2007
Threaded Mode