Hi, Suppose your Wage Structure is located on a sheet called WageStructure
and your employee pay are in the range starting in A1, with titles on the
first row and in the first column and the first number in B2.

Then in the deduction range, say B7 enter the following formula

=SUMPRODUCT(Sheet3!B2*WageStructure!$B2:$D2)

Copy it down three rows and over as many columns as needed.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sgl" wrote:

My apologies this was wrongly posted in the Excel Programming group

Hi all,

I am using Excel 2003 with Vista.
I have a reference WkSht with all the Tax, Social Security, Union Dues rates
laid out against each element of the Wage Structure package. The Table is
laid out as follows:

Tax Soc
Union etc etc
Security
Dues

Basic Wages 10% 5% 3%
Leave Pay 7.5% 3% 3%
Subsistence 5.0% 2.5% 3%

In the Payroll Calculations WkSht I have the Payroll calculations for each
employee and for each element of the Wage Structure

Employee Name A B C
D etc etc

Basic Wages 1,000 750 650 500
Leave Pay 500 375 300 250
Subsistence 160 160 160 160
etc
etc

What I need to do is to calculate the various deductions against each
element of the Pay Structure in a separate table in the same WkSht as the
Payroll Calculations. The table is laid out as follows:

Employee Name A B C D etc
etc
Tax
Social Security
Union Dues
etc
etc

The layout of the Tables cannot be altered as this is part of a much larger
project.

Any assistance much appreciated/Many thanks/sgl