Help with SUMIFS

[jiteshmehta2k1]

I have a list of countries I am interested in, in one sheet.

In the second sheet, I have a list of companies as rows and the number of employees each company has across different countries. Each country is a column.
I need a formula to determine what is the total number of employees the company has if I consider only the countries listed in the first sheet.

Thanks in advance for help. Attached excel sheet,


Regards,

[NeedForExcel]

Try this -

=SUMPRODUCT(('Country Raw Data'!$A$2:$A$30='Raw Data'!$C$1:$H$1)*$C$2:$H$2)

Also correct the Spelling mistake on the Raw sheet. You have mentioned County instead of Country, which will return wrong results..

[FDibbins]

Sorry, I see nothing to sum?

[jiteshmehta2k1]

Thanks Dave. Your solution worked.