Help!!!!
 

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

Help!!!!
 

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

Help!!!!
 

SumIf will do it for you:

=SUMIF(B1:B5,"=Interest",C1:C5)

Formula assumes your dates start at A1, the categories (Cash or Interest)
start at B1, and the range to sum starts at C1
--
Kevin Backmann


"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

Help!!!!
 

"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

If those are in the range A1:C4, then try:

=sumif(B1:B4, "Interest", C1:C4)

That reads: for each cell in B1:B4, if the cell is "Interest", add the
value from the corresponding cell in C1:C4.

Help!!!!
 

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

Vaya con Dios,
Chuck, CABGx3



"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

Help!!!!
 

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