Auto fill cells depending on Drop down List selection

Hi,

I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.

This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)

I have made drop down lists to select each of the values for the three conditions and want to show the total for them

i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.

i.e. i am away for 6 days i get £15 extra, if i am in Europe i get another £50 and if i work 12 hours i get £30.

I want to be able to calculate this total in each cell for that day.

I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.

Here is a copy of the workbook and also what the allowance table we have to work from.

I am basically trying to make it that i can select the necessary parts and for it to display the total allowance for that individual day.

The formulas i have currently got in use to total up the number of each drop down selection are fairly long, but if i can get the spreadsheet to total up for each day then i will not need these.

I attached the table just to show what i was hoping to get the workbook to be able to total up for each day.

From the examples i have added in, it shows that i can total the amount of times each box has a selection using countif and then to just multiply the result by the amount paid for a total at the end of that row.

The red figures in the bottom right of each example day is what i am trying to get the spreadsheet to auto calculate as a sum of the three different payments for the drop down box selections.

i.e. i get £15 for working a 6 day week + £50 as i am in europe and not the UK + £15 for working an 8 hour day =£80

What i am hoping to do is remove all the result boxes from the bottom of the sheet and just have it auto adding the amount paid for each of the different drop downs and to display the total in each day.

I know it would be easier to just have the amounts as the drop downs but that means i got to remember the amounts for the different selections this way i can just enter how long and where.

I hope this explains it a bit better.

unfortunately not at the moment as i just took a screen shot of it as i only have it in a pdf document.

I will try Vlookup or Index/Match once i get it into an excel, until then i will use what you posted and sent back to me before.

Many Thanks for helping me out with this.

Again many thanks for the help.

I will try that in a bit when i get a chance

I just had a look at what you sent back to me and that is exactly what i have been trying to do.

Thanks