|ok let me try to explain this a little better|
in the sheet that i have been trying to create, Cells C - I = monday - sunday. Cells B9 - B14 is a list of equipment that has to be accounted for on diffrent job numbers everyday. Taking just the first two rows of the sheet that i have C9 - I9 and C10 - I10 all have a set drop down list of all the job numbers that are active. cells J9 - J14 are the daily value amounts for each piece of equipment.
so what i want to do is when they choose a job number for the equipment that was used, i want the daily value for the equipment with that same job number for that day to tally up in the final Cell which we'll say is B18.
so if they used the listed equipment on monday (C9) they would select a list item that match the job number from the drop down and it would total $90(J9)in the final cell (B18), if they didnt use that equipipment the charge would be $0 in the final cell (B18). repeate for (C10). also totalling in (B18) which is why i need for the final to add both J9 and J10 if both C9 and C10 have been populated with the drop down job number...
did that help explain or make it worse?