Array formula help

[Steve17701]

test.xlsx
	F	G	H	I	J	K
4	I am using Excel 2019 on Windows. I have a table of numbers I want to count the number of matches with the numbers above, In cell D3 I used a Count(Match()) array formula and it works. However, when I tab to add a new row the the formula in D3 changes. The first parameter to the Match function becomes a two dementional array, as does the the formula in D6. Why? What am I doing wrong? Is there a better way?
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Sheet1

 

[Steve17701]

SUMPRODUCT failed after hitting tab for a new row.

 

[Steve17701]

Formula used was:
{=SUMPRODUCT(--(Table2[@[1]:[3]]=$A$18:$C$18))}

 

[Steve17701]

Formula used was:
{=SUMPRODUCT(--(Table2[@[1]:[3]]=$A$18:$C$18())}

Just like my original issue using {=COUNT(MATCH())}
{SUM(COUNTIFS()} appears to be consistent.

 

[Steve17701]

Strange behavior...where's Bill?

pbh.xlsm
	A	B	C	D	E
17
18	1	2	3
19
20	1	2	3	count
21	1	10	3	2
22	3	10	1	0
23
PPH

Cell Formulas
Range	Formula
D21:D22	D21	=SUMPRODUCT(--(Table2[@[1]:[3]]=$A$18:$C$18))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Dave Patton]

I tried the formulas with Excel 2010. The SumProduct worked with both versions but it was best on the second example.
With E5, the formula did not automatically fill with Tab.
When formulas yield strange results, it is sometimes because of the data. Ensure the numbers are numbers and not text.

SumProduct2022.xlsm
	A	B	C	D	E
3
4	n1	n2	n3	count	SumProduct
5	1	2	3	3	3
6	3	3	3	3	1
7	1	3	3	3	2
8	1	2	3		3
9
10	1	2	3
11	n1	n2	n3	Count
12	1	2	3	3
13	1	10	3	2
14	3	10	1	0
15	1	2	3	3
16
9a

Cell Formulas
Range	Formula
D5:D7	D5	=SUM(COUNTIFS(Table4[@[n1]:[n3]],$A$1:$C$1))
E5:E8	E5	=SUMPRODUCT(--(Table4[@[n1]:[n3]]=$A$1:$C$1))
D12:D15	D12	=SUMPRODUCT(--(A12:C12=$A$10:$C$10))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Dave Patton]

re Strange behavior

Try using Formulas Evaluate Formula

You may be able to identify what part of the formula is yielding the problem.