Got stuck with SUMPRODUCT - multiple criteria (text/numbers)

[MadsHusted]

Hi,

I'm working with a SUMPRODUCT formula to sum the total amount of occurrences in my workbook (+3800 lines).

The criteria are:
Array 1; if cell value matches other cell
Array 2; if cell value matches "text"

Either I get #N/A or 0.. I suspect it's related to formating issues but neither TRIM(), TEXT() nor formatting to General works.. I've tried to add ISNUMBER but it returns #VALUE !

I would appreciate any inputs. Let me know if you can't open the file.

Thank you.

Link to OneDrive: https://1drv.ms/x/s!AjXp0Ya_hoO0hmAmQRUzvSGhXNmu

 

[MARZIOTULLIO]

	A​	B​	C​	D​
1​	Article code	Product ABC code	Supplier code
2​	2000F34821422	CA	15837
3​	B43108A1	BB	15837
4​	32737CRC	N	54630
5​	AGLA403011P001	CA	15837
6​	SKPF12C08N	BB	15837
7​	KRLP7KRP006	BA	15837
8​
9​
10​
11​
12​
13​
14​
15​	Supplier code	AA​	BA​	CA​
16​	15837	0​	1​	2​
17​	54630	0​	0​	0​

<tbody>
</tbody>

Change in this way



B16=COUNTIFS($C$2:$C$7,$A16,$B$2:$B$7,B$15) copy across and down

 

[MadsHusted]

Thank you very much sir, this made my day!