SUMIF
want to use a sheet to reconcile credit card sales and cleared such as:
Date Visa/MC Cleared 02/01/06 125.50 x 02/02/06 174.50 x 02/03/06 150.00 where amount is charge sales for the day, and x means now deposited in bank, usually a 2-5 day lag period. want to sumif Visa/MC is Cleared=x above case would be 125.50+174.50=300., then when 150 clears total is 450 and so forth thanks |
SUMIF
=SUMIF(C:C,"x",B:B)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "reno" wrote in message ... want to use a sheet to reconcile credit card sales and cleared such as: Date Visa/MC Cleared 02/01/06 125.50 x 02/02/06 174.50 x 02/03/06 150.00 where amount is charge sales for the day, and x means now deposited in bank, usually a 2-5 day lag period. want to sumif Visa/MC is Cleared=x above case would be 125.50+174.50=300., then when 150 clears total is 450 and so forth thanks |
SUMIF
=SUMIF(C1:C3,"x",B1:B3) where C1:C3 is your range that could have "x" inserted and B1:B3 is your range of amounts. -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=510110 |
SUMIF
In D2 enter =Sumif(C2:C4,"x",B2:B4)
"reno" wrote: want to use a sheet to reconcile credit card sales and cleared such as: Date Visa/MC Cleared 02/01/06 125.50 x 02/02/06 174.50 x 02/03/06 150.00 where amount is charge sales for the day, and x means now deposited in bank, usually a 2-5 day lag period. want to sumif Visa/MC is Cleared=x above case would be 125.50+174.50=300., then when 150 clears total is 450 and so forth thanks |
SUMIF
thank you...it works
"reno" wrote: want to use a sheet to reconcile credit card sales and cleared such as: Date Visa/MC Cleared 02/01/06 125.50 x 02/02/06 174.50 x 02/03/06 150.00 where amount is charge sales for the day, and x means now deposited in bank, usually a 2-5 day lag period. want to sumif Visa/MC is Cleared=x above case would be 125.50+174.50=300., then when 150 clears total is 450 and so forth thanks |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com