| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confused on what to use ????? vlookup with different criteria
try sumproduct it allows multiple criteria. the values i have included in " " can be replace with a cell containing that value if it is easier =sumproduct((b1:b500="gyn")*(c1:c500="c")*(d1:d500 ="att")*(e1:e500)) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=561436 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Confused on what to use ????? vlookup with different criteria
Thankyou for your help
"Dav" wrote: try sumproduct it allows multiple criteria. the values i have included in " " can be replace with a cell containing that value if it is easier =sumproduct((b1:b500="gyn")*(c1:c500="c")*(d1:d500 ="att")*(e1:e500)) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=561436 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DCOUNTA Complex Criteria Question | Excel Worksheet Functions | |||
| vlookup with two criteria | Excel Worksheet Functions | |||
| vlookup with two criteria | Excel Worksheet Functions | |||
| Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
| VlookUp with Multiple Criteria? | Excel Worksheet Functions | |||
Hybrid Mode
