Help on formula

[MelanieZ]

Greetings!

I have the following columns:

A. Cost B. Plan C. Additional D.
Total
$100.00 OTN $35
$135
OTN2 $40
$0
$150.00 OTN4 $25
$175

How can i get the TOTAL field to calculate Column A and C only when there is
a value entered in Column A? In case you are wondering, the Additional
Column (c) has assigned values, however I don't want a total if there isn't
data in Column A?

I hope you understand my msg.

Thanks for any help.

 

[JMB]

Perhaps
=SUMIF(A3:A8,"<>"&"",C3:C8)
or
=SUMPRODUCT(--(A3:A8<>""),C3:C8)

 

[kassie]

If you mean on a row by row basis, then in D2 enter =IF(A2="","",A2+C2)

 

[kassie]

Oops, and copy down as far as you need to go, of course!