Countif with Match

[jevi]

Hi All,

I have the first table when I have 8 column and different names in it. Then I have table 2 where I have a list of names (it has more than table 1 and some might not be in table 1, but the one that are in table 1 are in table 2).

I would like a formula to do the countif for each name based on the match with the name.


Example Name: Jevi in only in column 1 so I count it one time on the row of table 2 where is Jevi.

Thank you so much,

 

[Fluff]

Without knowing where those cells are something like

=countifs(A:B, E2)

 

[hrayani]

is this what you want ???

VBA Working.xlsm
	A	B
1	Column 1	Column 2
2	Jevi
3	Ann	Jane
4		Ann
5		Bob
6	Robert
7
8
9	List	Formula To Count
10	Jevi	1
11	Ann	2
12	Jane	1
13	Bob	1
14	Robert	1
15	Julia	0
Sheet4

Cell Formulas
Range	Formula
B10:B15	B10	=COUNTIF($A$2:$B$6,A10)

 

[jevi]

Thank you Pluff and Hrayani it worked great...I thought would be such a complex formula that I even didn't try it, I was sure was not going to work even though I use this formula......feel like?

 

[Fluff]

Glad we could help & thanks for the feedback.