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
|