Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions |