Try:

=SUMPRODUCT(--(A1:A10="UAE"),--(B1:B10="Construction"))

HTH

"petess" wrote:

I am trying to generate returns from data in more than one column. E.g.
country and sector, so I want to count all the countries that are UAE as well
as Construction. Or Bahrain and Power, Qatar and Industry. Any ideas, guys?