# Two Totals from the same column

M

#### magmike

I want to create 2 different totals or sums from the same column. The first can be done from an auto sum. But the 2nd is eluding me. I only want to add into the total the rows where a different column is not null.

A B C
1 Amount Signed
2 Brown \$100 7/8/13
2 Cox \$200 7/9/13
3 Smith \$100
4 White \$300
5 Howard \$200 8/2/13
6 Total \$900
7 Signed \$500

How can I do this?

magmike

C

#### Claus Busch

Hi,

Am Mon, 5 Aug 2013 08:12:00 -0700 (PDT) schrieb magmike:
I want to create 2 different totals or sums from the same column. The first can be done from an auto sum. But the 2nd is eluding me. I only want to add into the total the rows where a different column is not null.

A B C
1 Amount Signed
2 Brown \$100 7/8/13
2 Cox \$200 7/9/13
3 Smith \$100
4 White \$300
5 Howard \$200 8/2/13
6 Total \$900
7 Signed \$500

try:
=SUMIF(C2:C8,"<>",B2:B8)

Regards
Claus B.

C

#### Claus Busch

Hi,

Am Mon, 5 Aug 2013 17:21:18 +0200 schrieb Claus Busch:
=SUMIF(C2:C8,"<>",B2:B8)

the formula above works if anything is in column C even if it is
negative.
For only values greater 0 try:
=SUMIF(C2:C8,">0",B2:B8)

Regards
Claus B.