Formulas
 

How do I create a formula that brings over a figure that has more than one
specific conditions. for example.

employee name in colum a, workplace in colum b, machine in colum c, and
total hrs work in colum d.

If an employee name, workplace and machine details in row 1 = to the
employee name in colum a ,workplace in colum b and machine in colum c then it
must bring over the total in colum d

--
laureen

Formulas
 

Hi Laureen

The generic formula would be
=SUMPRODUCT((A1:A1000=criteria1)*(B1:B1000=criteri a2)
*(C1:C1000=criteria3),D1:D1000)

OR referrring to row1.

=SUMPRODUCT((A1:A1000=A1)*(B1:B1000=B1)*(C1:C1000= C1),D1:D1000)

If you are using XL2007; refer help on SUMIFS()

--
Jacob


"Laureen" wrote:

How do I create a formula that brings over a figure that has more than one
specific conditions. for example.

employee name in colum a, workplace in colum b, machine in colum c, and
total hrs work in colum d.

If an employee name, workplace and machine details in row 1 = to the
employee name in colum a ,workplace in colum b and machine in colum c then it
must bring over the total in colum d

--
laureen