Help on formula
=(C2+A2)*(A20)
copy down as needed.
"MelanieZ" wrote:
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.
|