Adding Cells in Multiple Worksheets

KarenAter · Apr 3rd, 2002, 08:50 AM

I am having trouble adding cells in multiple worksheets. The cells I want to add have formulas in them so that if there is no numbers to add, the cells will be blank. When I try to add the blank cells I get a #Value! error code. I have tried to use the sum function and the sumif and neither works. Any suggestions? I would gladly send the workbook to anyone who could look at it. The formulas in the cells that I am trying to add are: =IF(SUM(D6:D23)=0,"",SUM(D6:D23)). This is in cell D24 on several worksheets. If there are numbers in all of the cells I am trying to calculate, it works. If any of the cells are blank, I get the error code. Thanks in advance for any help anyone can give me.

Karen

kinkyparamour · Apr 3rd, 2002, 09:18 AM

Karenater

I was just playing with your formula and in a blank cell I get a blank, no error. Maybe you could give more info as to what the problem is.

Denny

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

Apr 3rd, 2002, 08:50 AM	#1
KarenAter New Member Join Date: Apr 2002 Location: Blue River Services, Inc. Posts: 2	I am having trouble adding cells in multiple worksheets. The cells I want to add have formulas in them so that if there is no numbers to add, the cells will be blank. When I try to add the blank cells I get a #Value! error code. I have tried to use the sum function and the sumif and neither works. Any suggestions? I would gladly send the workbook to anyone who could look at it. The formulas in the cells that I am trying to add are: =IF(SUM(D6:D23)=0,"",SUM(D6:D23)). This is in cell D24 on several worksheets. If there are numbers in all of the cells I am trying to calculate, it works. If any of the cells are blank, I get the error code. Thanks in advance for any help anyone can give me. Karen

Apr 3rd, 2002, 09:18 AM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Karenater I was just playing with your formula and in a blank cell I get a blank, no error. Maybe you could give more info as to what the problem is. Denny