summ if blank

[Altamija]

Hello,
Can someone please help me figure out a formula to calculate the sum of data in cells B5 + D5? If D5 is empty, use C5 to sum it with B5.

Thank you!

 

[Sergius]

Hello! Is this what you wanted?

Book1
	B	C	D	E
5	5	2		7
Sheet2

Cell Formulas
Range	Formula
E5	E5	=IF(D5<>"",B5+D5,B5+C5)

 

[ipon70]

You could do something like =IF(D5="",C5+B5, B5+D5)

 

[Altamija]

I appreciate your help, but it seems it didn't work. Please see the image below: Column M still calculates just C5+B5.

 

[Sergius]

In your fifth line in any situation, it will return zero. But in the ninth, with an empty cell D9, should be returned 70347

 

[Altamija]

Correct; I had an incorrect formation in column D, but the formula now works as intended. Thank you so much for the help.