Using two ranges to calculate and return results

[kopapa]

Ok, this is tricky for me:

As you can see (in the sample file) there are two sheets in the workbook.
The worksheet "TOTALS" lists values calculated by worksheet "PRICES".

What I want to do is this: For each value in column W (from W10 and below) & each date in column X (from X10 and below) I want to calculate AF18, paste it in column Y (from Y10 and below) and continue with the next values until no values.
Each value from W range and each date in X range must be entered in formulas in "AB9:AF18" but "AB9:AF18" must not necessarily be on the same sheet.

"AB9:AF18" calculates tax for each period of time between X date and today (E3) based on specific tax percentages (AD10:AD14) for specific periods of time (AB10:AC15).

Any help would be greatly appreciated!
Thanks!

PRICES2013_B.xlsm

[kopapa]

Anyone out there?
Not even a hint?

[kvsrinivasamurthy]

Pl see attached file with formula.

[kopapa]

Pl see attached file with formula.

This is very nice and simple (simple is better)
Many thanks!

BUT...

What if ranges "Y10:Y" and/or "AB10:AF" were considerably larger? Then we would end up with an extra-extra long formula (in "Y10:Y") to repeat. Right?

So, in that case would it be possible to use a macro to accomplish same results?

Thanks in advance. Your reply is much appreciated!

[kvsrinivasamurthy]

In the formula Range AB10:AD14 is only used , which is same irrespective of your Y column range. Columns AE & AF are not required for formula.
The formula in Y10 is simply dragged down. No need to retype.
I feel Formula is better than Macro.

[kopapa]

In the formula Range AB10:AD14 is only used , which is same irrespective of your Y column range. Columns AE & AF are not required for formula.
The formula in Y10 is simply dragged down. No need to retype.
I feel Formula is better than Macro.

Ok, I totally get you and I saw that AE & AF were reduntant. What I said (perhaps I didn't made myself clear) is that if -for example- the range was AB10:AD50 (with 41 different time periods) then the formula in Y column would be huge because each one of the AB:AC time frames would have to be checked.
This is more than a scenario because I may have to enter AD values prior to AB10:AC10 period.

BUT, still your solution was lifesaving

[kvsrinivasamurthy]

Pl see i have changed formula to suit your requirement.
Pl see the attached file.Previous formula also retained for comparison.

[kopapa]

Pl see i have changed formula to suit your requirement.
Pl see the attached file.Previous formula also retained for comparison.

Thanks a lot for your prompt replies and your valuable help!