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.

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


"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.

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

Kassie Kasselman


"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.

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

--
Hth

Kassie Kasselman


"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.

=(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.