SUM question

[oli123]

Hello, im looking for a formula that will calculate the values in cell A1 and B1 and return a 0$ amount if either of these cells are empty/no data. Any help would be much appreciated. Here's my formula:

Sheet1

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>A</td><td>B</td><td>C</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="background-color: rgb(192, 192, 192); text-align: right;">230</td><td style="background-color: rgb(192, 192, 192);"> </td><td style="text-align: right;">230</td></tr></tbody></table>
<table style="font-family: Arial; font-size: 10pt; border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>C1</td><td>=SUM(A1,B1)</td></tr></tbody></table></td></tr></tbody></table>
THanks,
Oli

Excel tables to the web >> Excel Jeanie HTML 4

 

[shg]

How about ...

= if(count(a1:b1)=2, sum(a1:b1), 0)

 

[jeffreybrown]

How about...

=IF(COUNT(A1:B1)<2,0,SUM(A1:B1))

 

[snoopyhr]

or try this seems to be working:

Excel Workbook
	A	B	C
1	230	5	235
2	100		0
3		20	0
Sheet8

 

[oli123]

Thank you both the help and prompt reply!

Cheers,
Oli