| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
