Calculating an amount between two columns

Microsoft Microsoft excel 2007 full vers...
March 19, 2010 at 16:34:44
Specs: Windows XP
I have an excel spreadsheet that I track payments received and how they were received. I was trying to figure out a formula that will quickly tell me the dollar amount for total cash/check/credit card received. Here's an example below:

A B C D
1 Payment Cash Check Credit
2 $32.43 X
3 $140.00 X
4 $10.98 X
5 $81.07 X
6 $32.43 X
7 $10.98 X
8 $81.07 X
9 $25.94 X

See More: Calculating an amount between two columns

Report •


#1
March 19, 2010 at 17:01:41
If you use the pre tags (found above the Comments box) you can line you data up in columns. Since I don't know where you had your X's, I choose my own cells:

    A          B       C        D
1 Payment    Cash    Check   Credit
2 $32.43       X
3 $140.00              X
4 $10.98                       X
5 $81.07       X
6 $32.43       X
7 $10.98                       X
8 $81.07       X
9 $25.94               X

This will sum the Cash payments:

=SUMIF(B2:B9,"X",$A$2:$A$9)

Drag it to the right to Sum the other 2 columns.

Please review the Excel Help files for SUMIF for more information.


Report •
Related Solutions


Ask Question