Help on formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MelanieZ - 15 Dec 2006 02:18 GMT

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.

Reply to this Message

JMB - 15 Dec 2006 02:35 GMT

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

> Greetings!
>
[quoted text clipped - 17 lines]
>
> Thanks for any help.

Reply to this Message

kassie - 15 Dec 2006 04:18 GMT

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

Signature

Hth

Kassie Kasselman

> Greetings!
>
[quoted text clipped - 17 lines]
>
> Thanks for any help.

Reply to this Message

kassie - 15 Dec 2006 04:18 GMT

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

Signature

Hth

Kassie Kasselman

> Greetings!
>
[quoted text clipped - 17 lines]
>
> Thanks for any help.

Reply to this Message