leaving cell blank

		Microsoft Office Forums > Microsoft Excel > Excel
leaving cell blank

FAQ

Thread Tools

Display Modes

04-06-2017, 08:07 AM

Trapshooter1956 Trapshooter1956 is offline

Windows 7 32bit leaving cell blank

Office 2007

Advanced Beginner

Join Date: Mar 2017

Posts: 31

Trapshooter1956 is on a distinguished road

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.

Attached Files

DIGITAL TIME CARD.xlsx (16.1 KB, 13 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 AM.