Not much
=SUMPRODUCT(--(A1:A10="UAE"),--(B1:B10="Construction"),C1:C10)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"SteveG" wrote in
message ...
My post assumed you are trying to count the number of occurences. If
you are trying to "return" data from a different column if the
conditions are met, that would be different.
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=529186