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
|