VLOOKUP Help Please

[Ben1985]

Hey guys,

I've attached a sample sheet as it's hard to explain.

Basically I want to be able to go through and put my bank statement into different categories, fuel/bills/etc. So at the top I've put a table and in that table I would like the final sum of each category.

So I would need to use a VLOOKUP formula to do this I think?

Any help would be greatly appreciated.

Regards,

BenExampleONE.xlsx

[benishiryo]

hi Ben, probably:
=SUMIF($I$10:$I$19,B2,$E$10:$E$19)

or perhaps you could show us what you want to show

[twiggywales]

might be missing something here but have you tried sumifs

Please Login or Register  to view this content.

[Brumbot]

Hi Ben,

Try this?:

Please Login or Register  to view this content.

Copy in C2 and copy down?

[twiggywales]

oh beni you little rascal

[benishiryo]

@twiggywales:

havent seen you in awhile. happy new year to you~

[Ben1985]

Hi Ben,

Try this?:

Please Login or Register  to view this content.

Copy in C2 and copy down?

Hi,

This works perfectly.

Thanks alot!

Ben