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>
</tbody>
Data that needs to be counted
<tbody>
</tbody>
Thank you in advance
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