Microsoft Microsoft excel 2007 full vers...

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

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

Ask Your Question

Weekly Poll