This works placed in Sheet2 wth data in Sheet1:

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

(Perhaps you should state your requirements more clearly)

"petess" wrote:

Toppers,

Further to my earlier post, however, I find that I cannot use the formula
you suggest to work with data from ANOTHER worksheet within the same Excel
file... I can still get the answers I need in the same worksheet, but this
would be more elegant.

Petess