Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |