CountIf multiple conditions - need help please!

[GTN]

Hello,

Firstly, thanks for reading my message.

I'm trying to calculate something using Countif but it doesn't seem to be working.

Sheet 1. In column A, I have a list of countries, for example, Ireland, United Kingdom, Brazil etc..; . In columns B,C,D,E,F I have types of companies, for example, Marketing, Advertising, Transport etc...

Sheet 2. I have the list of Countries descending in Column A3 and down and in B2,B3,B4 etc... I have the types of companies.

So if in Sheet 2 A3 is Brazil, I would like to calculate in B3 the number of times the word Marketing is in the columns B,C,D,E,F of Sheet 1 in just Brazil.

Any help would be greatly appreciated.

[mcmahobt]

Can you upload a sample document with how your data is setup?

[ChemistB]

Not sure exactly how your data is laid out. Can you upload a small sheet showing sheet1 and sheet2 (Go Advanced>Manage Attachments)
Sounds like SUMPRODUCT will work for you.

[GTN]

Copy of Excel Sample.xlsx

Thanks in advance

[Jonmo1]

Based on the file you posted...

In Sheet1 B3
=SUMPRODUCT((Sheet2!$B$2:$B$3355=$A3)*(Sheet2!$C$2:$F$3355=B$2))
Fill right/down.

[mcmahobt]

A different approach:

B3 in Sheet1:

Please Login or Register  to view this content.

Drag down/across.

[GTN]

Thank you both for your help.

I got it to work with Jonmo1 's formula.

Thanks again Huge help

[Jonmo1]

You're welcome.