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?

Thanks in advance,
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top