get SUMIF

[reno]

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

[Bob Phillips]

=SUMIF(C:C,"x",B:B)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"reno" <[email protected]> wrote in message
news:[email protected]...
> 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

[mphell0]

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

[Jim May]

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

[reno]

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