Help!!!!

S

stapleton2308

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
 
L

Lynn Moralee

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

joeu2004

stapleton2308 said:
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
Click to expand...

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.
 
K

Kevin B

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
 
N

Nika Lampe

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:
 
Top