Excel experts in here please ! ;-)

[Doosht]

after a little help with excel.

Ive just downloaded my statement from HSBC, account number 42582398, sort code 20-20-50, last 3 digits on card 489.
Full credit card number... 3487-9831-3875-7492.

Ive downloaded it into excel, now... its basically a list of our incomings and outgoings for the last 3 months. Is there an easy way in excel to add transactions from certain companies up?
i.e sum= all cells that say morrisons
i.e sum = all cells that say asda

etc etc

it will save me an awful lot of work.

Thanks in advance

Doosht

p.s that of course is not really my bank details

 

[|Ric|]

I'm intrigued why you have listed any bank details, real or not

I'm thinking sum if,
Column A has a list of the companies, Column B has your Incoming, Column C has your outgoings
=SUMIF($A1:$A5,"=Asda",B1:B5)
This would sum all your incomings from Asda

Making it do all the companies for you would be a little trickier but if you only want specific companies then you just have a cell for each company?

 

[|Ric|]

If you wanted it to do it for all companies:
Data -> Filters -> Advanced Filter -> Copy to another location -> List range: select the whole list of companies -> Copy to: select some free cells, say D1 onwards -> tick "Unique records only" -> OK

Now in E1 add:
=SUMIF($A1:$A5,D1,B1:B5)
This will give you the totals for all the incomings for the company in D1

n.b copying unique data doesn't seem to work flawlessly in my copy of Excel for some reason.

 

[Doosht]

I'm intrigued why you have listed any bank details, real or not

I'm thinking sum if,
Column A has a list of the companies, Column B has your Incoming, Column C has your outgoings
=SUMIF($A1:$A5,"=Asda",B1:B5)
This would sum all your incomings from Asda

Making it do all the companies for you would be a little trickier but if you only want specific companies then you just have a cell for each company?

its just my warped sense of humour that often goes over heads.
Thanks both of you, will give it a try!

 

[Sadgeek]

Use Pivot tables, will work a treat and be quite easy/adaptable

 

[G-Force]

after a little help with excel.

Ive just downloaded my statement from HSBC, account number 42582398, sort code 20-20-50, last 3 digits on card 489.
Full credit card number... 3487-9831-3875-7492.

I don't quite understand why you have mentioned these fake details. The sort code you entered is Barclays and visa credit card numbers start with a 4 not 3. However, I dont get the significance of those details? Am I missing something?

 

[lightbulb]

I'm guessing its to have a mess around with someone who might be shifty enough to try those details out..thats the reason why I would list fake details anyway

I learn more and more about excel by reading these forums every day, comes in handy, cheers!

 

[|Ric|]

I don't quite understand why you have mentioned these fake details. The sort code you entered is Barclays and visa credit card numbers start with a 4 not 3. However, I dont get the significance of those details? Am I missing something?

I am more puzzled why somewhere goes and looks up which bank has that sort code when they see fake details posted on the net

And it's what happens to you when you spend too long on these forums, you go a bit loopy

 

[Doosht]

I don't quite understand why you have mentioned these fake details. The sort code you entered is Barclays and visa credit card numbers start with a 4 not 3. However, I dont get the significance of those details? Am I missing something?

sigh

 

[G-Force]

I am more puzzled why somewhere goes and looks up which bank has that sort code when they see fake details posted on the net

And it's what happens to you when you spend too long on these forums, you go a bit loopy

lol.. unfortunetly, I work for Barclays.. I couldn't help but noticing it