Forgive me but I am an artist and have little knowledge of spreadsheets, my problem is.
I'm trying to get yearly sum totals from my monthly expenses from my openoffice spreadsheet, 12 sheets, 1 for each month and I need to create a master sheet with totals for each of my expenses categories, for example "Insurance" which is a category in my expenses categories in column G and its monetary value is held in column D. I've searched VLOOKUP in a hope of finding my way but as you can see from this example"=VLOOKUP(SHEET(april);AREAS(april.A2:G27);MATCH("Insurance" ))" I am hopeless, I'm intellegent enough to be able to move forward through all my yearly totals if I can only get one category sumtotal to work, help
