Formula to ignore blank cells with SUM?

I want to SUM the last the two cells above, using A+B formula,but as a SUM formula it adds with blank cells .How to Sum only if any of the two cells are not blank?

Example:


A4=2395,4 B4=200 ---------- Formula:
A5=2595,4 B5=444 -------- A4+B4
A6=3039,4 B6=-339 ------- A5+B5
A7=2700,4 B7=-500 ------- A6+B5
A8=2200,4 B8= ----- A7+B7
A9=2200,4 B9= ------ A8+B8
A10=2200,4 B10= ----- A9+B9
A11=2200,4 B11= ------ A10+B10
A12=2200,4 B12= ------- A11+B11


Want like this:

A7=2700 B7=-500
A8=2200,4 B8=0
A9= B9=
A10= B10=
A11= B11=

With B8=0 , A9 is blank and B9 is blank

.
Not certain I understand your question ... but won't this also provide the answers you are seeking ?

	A	B	C	D	E	F	G
1
2
3
4	2395	200	2595		Formula in C4 & drag down"
5	2595	444	3039		=SUM(A4:B4)
6	3039	-339	2700
7	2700	-500	2200
8	2200		2200
9	2200		2200
10	2200		2200
11	2200		2200
12	2200		2200

The results are the same, If B is blank then cell A is repeated such A4=200 B5= A6=200 B6= I want A6 to be blank

Result: =if(and(a4="",b4=""),"",A+B)

A4=2395,4 B4=200
A5=2595,4 B5=444
A6=3039,4 B6=-339
A7=2700,4 B7=-500
A8=2200,4
A9=2200,4

I attached a workbook to show the problem

The formula worked , Thankyou

Originally Posted by Mr.Castle

The formula worked , Thankyou

You're welcome, thanks for the feedback.

Add rep would be appreciated, click on the "Star" at the lower left corner of posts you found helpful.

If your issue has been "Solved", please mark the thread as such, Thank You.