Hi
Every time I receive an estimate/invoice for work to be undertaken, I add it to an excel sheet (Invoices) that captures relevant information about that piece of work e.g. which department it's for, what initiative it relates to, etc.
What I would like to be able to do is add another sheet (Budget) to the beginning of the workbook that lists each initiative and it's individual budget and shows me how each project is performing against budget.
Essentially, I need to build a formula that:
- Takes a single text value in sheet Budget
- Looks up occurrences of that text value in sheet Invoices
- Totals the sum of all the related numerical values for that text value (that will be on the same row, but in a different column)
I hope that makes sense. Attached is a spreadsheet that hopefully makes it clearer.
I'm sure this is terribly simple, but it's been stumping me for days and I'd appreciate any help available. I've searched the forum and came up with a formula that used indexes and arrays, but I can't get the bloody thing to work!
Many thanks in advance
paul
Bookmarks