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

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History