how to Multiply and Add multiple cells ignoring blanks or text

[KariSaga]

I am not very good with excel and need some help. I have searched but not finding what I need. I am trying to figure out a simple formula that calculates multiple cells while ignoring blanks or any other text for cell D. I was trying to use isnumber eg... =IF(AND(ISNUMBER(A2), ISNUMBER(B2)),(A2*B2)+C2,” “)

The end result is below.

A2*B2+C2

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]400[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]400[/TD]
[TD][/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]600[/TD]
[TD]N/A[/TD]
[TD]1200[/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

What would happen if A or B are blank or text?

Try this




=IFERROR(VALUE(A2),0)*IFERROR(VALUE(B2),0)+IFERROR(VALUE(C2),0)