=SUM

justine · May 14th, 2002, 08:01 AM

Ok, this is a simple one I'm sure, but I can't figure it out.

I have a spreadsheet with the Employee # (in cell B4). Employee name(in cell C4) and dept. (in cell D4) then from E4 thru K4 I have their daily hours. In L4 is the total. I would like the total to show a blank cell if there isn't anything entered into B4, C4 or D4. How can I do this? My formula so far is =SUM(E4:K4)

Thx!

crimlet · May 14th, 2002, 08:08 AM

try =if(concatenate(b4,c4,d4)="","",sum(e4:k4))

Mudface · May 14th, 2002, 08:08 AM

Following should be OK:-

=IF(OR(B4="",C4="",D4=""),"",SUM(E4:K4))

justine · May 14th, 2002, 08:12 AM

The IF(OR was exactly what I was looking for. Thanks!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:01 AM	#1
justine New Member Join Date: Feb 2002 Posts: 27	Ok, this is a simple one I'm sure, but I can't figure it out. I have a spreadsheet with the Employee # (in cell B4). Employee name(in cell C4) and dept. (in cell D4) then from E4 thru K4 I have their daily hours. In L4 is the total. I would like the total to show a blank cell if there isn't anything entered into B4, C4 or D4. How can I do this? My formula so far is =SUM(E4:K4) Thx!

May 14th, 2002, 08:08 AM	#2
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	try =if(concatenate(b4,c4,d4)="","",sum(e4:k4))

May 14th, 2002, 08:08 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Following should be OK:- =IF(OR(B4="",C4="",D4=""),"",SUM(E4:K4))

May 14th, 2002, 08:12 AM	#4
justine New Member Join Date: Feb 2002 Posts: 27	The IF(OR was exactly what I was looking for. Thanks!!!