Countif with 2 matching columns needed

[pomeroi]

I have the formula to create a 'countif' for one particular word in a column and count but how do you include a second word from another column if they match?

Please see attached that I am trying to achieve.
Basically to show a top list of countries but also matching the word 'Distribution' that comes from another column.





Bok1.xlsxBok1.xlsx

[thenewkidd]

I just used a helper column, There is probably a smarter person than I that could do it in one column but for me,
I just use a helper column =CONCAT(B2,D2) in E2 Copy down
Then in in Cell B18 =COUNTIF($E$2:$E$15,CONCAT(A18,"Distribution")) and copy down.

[tanasedn]

Maybe:

Please Login or Register  to view this content.

[sandy666]

something like this ?

country	kind	Count of country	percent
Abu Dhabi, UAE	Distribution	2	22.22%
France	Distribution	2	22.22%
Spain	Distribution	1	11.11%
UK	Distribution	1	11.11%
USA	Distribution	3	33.33%
Grand Total		9	100.00%

[pomeroi]

Yes, that is perfect Sandy!

What was the formula you used?

[sandy666]

this is Pivot only

[pomeroi]

Not sure on how to use pivot - fyi, I'm pulling the data from a seperate tab....

[sandy666]

fyi, I'm pulling the data from a seperate tab....

it doesn't matter which tab is a source of data

Not sure on how to use pivot

have you never used Pivot table ?