Hi Rob,

I am not quite sure what you need, but if you have date in column A, Type
(cash, interest) in column B and Value in column C, you can sum values by
type, using the formula:
=SUMIF(B1:B4,"Interest",C1:C4)

Instead of comma that separates criterias, you sometimes need to use ; (it
depends on list separator, defined in operating system).

If this is not what you need, please clearify what exactly you need.

Regards,
Nika Lampe

"stapleton2308" je napisal:


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