Calling all Excel gurus!
I run a spreadsheet, part of which I put flying hours, all billed at different rates.
So for one day you'd have maybe 5 different 'rate' columns with the total flying for the day at the end of the row.
The flight can relate to 8 different jobs, ie charter, personal, business1, business2 etc.
So first column of spreadsheet is a column where I identify which business to invoice with numbers 1- 8.
I need to show how many hours I've done for each category 1- 8.
What I need to work out is how I can sum all the hours on the right, that have a particular reference on the left to give me 8 totals, each may have a mix of the 5 different charge rates.
Codes on left will not be in order so VLookup doesn't work!
Code Date Rate1 Rate2 Rate3 etc
3 0.8 0.4 0.5
1 1.7 1.8 1.1
1 0.2
4 1.7 1.6
Thank you in advance