Thread: leaving cell blank
View Single Post
 
Old 04-06-2017, 08:07 AM
Trapshooter1956 Trapshooter1956 is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Mar 2017
Posts: 31
Trapshooter1956 is on a distinguished road
Default 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
File Type: xlsx DIGITAL TIME CARD.xlsx (16.1 KB, 13 views)
Reply With Quote