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