need help with a formula

[Guest]

I want to add the values in cells K14 + L14 if cell DA14 is blank and put the
sum in a fourth cell. If it is not blank enter a zero as the sum. I think the
function I need is "sumif" but I cannot get the correct answer. I hope
someone can guide me with this,

 

[Myrna Larson]

You just need IF

=IF(ISBLANK(D14),K14+L14,0)

 

[Guest]

Thanks very much

You just need IF

=IF(ISBLANK(D14),K14+L14,0)

 

[Ron Rosenfeld]

I want to add the values in cells K14 + L14 if cell DA14 is blank and put the
sum in a fourth cell. If it is not blank enter a zero as the sum. I think the
function I need is "sumif" but I cannot get the correct answer. I hope
someone can guide me with this,

In the "fourth" cell:

=IF(DA14="",K14+L14,0)


--ron