Hello,
Is it possible to have a separate column for interest? - then you can use
autosum to get your totals quite easily.
Lynn

"stapleton2308" wrote:


Hi i have the following data from my bank statement:

05/06/05 Cash £5.00
01/07/05 Interest £5.34
01/05/05 Cash £10.00
01/09/05 Interest £4.37

What i want to do is at the bottom of it all is have a cell which adds
up all the "interest" for me which is on the spread sheet

help much appreciated!!!

thanks

rob


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=553574