Two Totals from the same column

[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?

Thanks in advance,
magmike

 

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

 

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