Use

=B2*SUM(Reference!$B2:$D2)

and copy down and across

--
__________________________________
HTH

Bob

"sgl" wrote in message
...
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