Formulas

[Laureen]

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

 

[Jacob Skaria]

Hi Laureen

The generic formula would be
=SUMPRODUCT((A1:A1000=criteria1)*(B1:B1000=criteria2)
*(C1:C1000=criteria3),D11000)

OR referrring to row1.

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

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