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