# 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 D1 Payment Cash Check Credit 2 \$32.43 X3 \$140.00 X 4 \$10.98 X5 \$81.07 X 6 \$32.43 X7 \$10.98 X 8 \$81.07 X 9 \$25.94 X

See More: Calculating an amount between two columns

#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