What i would like to do with the following example is use the rounddown function to round all occurances of "ATM" in column B that are greater than 4.99, down 1 decimal place (ie $41.50 to $40.00) then use the sumif function to subtract the actual total of all "ATM" transactions, to get a total of the fee's that I'm paying at the ATM to the banks atm itself. In the example below, the total should be $1.50..can I do this?

Thanks! Robbie

A B C D E

Date # Payee Amount Balance

8/6 ATM BNH ($41.50) $246.36

8/6 ATM Fee ($0.75) $245.61

8/6 VISA Texaco ($17.00) $228.61

8/7 ATM Walpole ($20.00) $208.61

8/7 ATM Fee ($0.75) $207.86