Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minimum With Two Criteria
Hi all,
I would like to run a variety of functions against a payrate table But I can't seem to get the first function to work The formula is returning 0, but should return $9.00 The table is setup correctly with no breaks in data I visibly reviewed all items since HR sent me the table-all looks correct Do you see any errors in my formula below or any other ideas? Thanks! goss =SUMPRODUCT(MIN((tbl!A$2:A$257=$A$1)*(tbl!$D$2:$D$ 257=$A4)*(tbl!$E$2:$E $257))) Where $A$1 = New Hire (sp is correct copied from tblPayRate) Where $A4 = Cashier (sp is correct, copied from tblPayRate) Where Col A is "New Hire" or other designation Where Col D is "Cashier" or other position Where Col E is range of values |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum IF | Excel Worksheet Functions | |||
Minimum Value | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
find minimum of range based on multiple criteria | Excel Worksheet Functions | |||
Minimum and Maximum with Complex Criteria | Excel Discussion (Misc queries) |