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, 11 views)

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

__________________
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

Thanks didn't think of that.

If this takes care of your problem indicate the thread as solved in the "Thread tools" drop down.
Thx

__________________
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