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

<tbody>
[TD="class: xl65"]Cell A[/TD]

[TD="class: xl65, align: right"] 111256
[/TD]

[TD="class: xl65, align: right"] 365446
[/TD]

[TD="class: xl65, align: right"]156489[/TD]

[TD="class: xl65, align: right"]186878[/TD]

[TD="class: xl65, align: right"]546844[/TD]

</tbody>

Data that needs to be counted

[TABLE="width: 320"]
<tbody>[TR]
[TD="class: xl66, width: 64"]A[/TD]
[TD="class: xl66, width: 64"]B[/TD]
[TD="class: xl66, width: 64"]C[/TD]
[TD="class: xl66, width: 64"]D[/TD]
[TD="class: xl66, width: 64"]E[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]COUNTIF[/TD]
[/TR]
[TR]
[TD="class: xl65"]111256
[/TD]
[TD="class: xl65"]365446
[/TD]
[TD="class: xl65"]1648976[/TD]
[TD="class: xl65"]464631[/TD]
[TD="class: xl66"]2
[/TD]
[/TR]
</tbody>[/TABLE]

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