Countif Horizontal with multiple criteria

[Rick__]

Hi,

I wondered if you could help as I've had a look on here and couldn't find how to do this exactly

I need you count how many part number are in a row based on a multiple criteria, as you can see below the multiple criteria below, as you can see in the example below 111256 & 365446 are counted in the row of data and it returns the number of times it appears.


Multiple criteria

Cell A

111256

365446

156489

186878

546844

<tbody>
</tbody>

Data that needs to be counted

A	B	C	D	E
				COUNTIF
111256	365446	1648976	464631	2

<tbody>
</tbody>

Thank you in advance

 

[FormR]

Hi, something like this maybe..

Excel 2013/2016
	A	B	C	D	E
1	Cell A
2	111256
3	365446
4	156489
5	186878
6	546844
7
8					COUNTIF
9	111256	365446	1648976	464631	2
Sheet2

Cell Formulas
Range	Formula
E9	=SUMPRODUCT(COUNTIFS(A9:D9,A2:A6))

 

[Rick__]

Thats worked perfectly, thank you for your help on this