summarize field comparisons, by count, with formula

[craigexcel]

I am working with some payroll data, where one field is a direct download of HR system data, and the comparator field was derived from some other related data.
My goal is to be able to use a formula (i.e. no helper Column(s)) that will summarize the differences between the 2 fields, such that those values with a +- difference of $0.01 can be assumed to be rounding differences, and all others can be assumed to be 'not a match'. Further, I'd like to be able to change a parameter in the formula that increases the $0.01 threshold, to see the effect of how many more 'matches' there would be by increasing that threshold.
In the attached, Columns D:H have formulas, and I manually entered "MATCH" in Column I where the differences would be considered a 'match' at the $0.01 threshold.
Increasing the threshold parameter to $0.03 would then find 3 'matches'.
I want to be able to share with the requestor the scale of 'matches' based on the threshold parameter

I've tried numerous iterations & combinations of IF, COUNT, COUNTIF, SUMPRODUCT, and maybe some others, but all without success.
I'd appreciate any suggestions for a formula (again, ideally, without helper columns), or a different approach to achieve this analysis.

payroll matched values - COUNT by criteria.xlsx
	A	B	C	D	E	F	G	H	I
1	actual values			ROUNDed values (displayed with 2 dec places)			delta - actual values: Field1 vs Field2	delta - ROUNDed & displayed to 2 dec places
2	Field1	Field2		Field1	Field2
3	15.2654	15.27		15.27	15.27		(0.004600)	-
4	9.34108	9.34		9.34	9.34		0.001080	-
5	12.1128	12.1		12.11	12.10		0.012800	0.01	MATCH
6	20.2	20.201		20.20	20.20		(0.001000)	-
7	4.699	5.34		4.70	5.34		(0.641000)	(0.64)
8	18.4	18.4		18.40	18.40		-	-
9	14.555	14.55		14.56	14.55		0.005000	-
10	10.25	14.6		10.25	14.60		(4.350000)	(4.35)
11	11.1	9.86		11.10	9.86		1.240000	1.24
12	16.4	16.43		16.40	16.43		(0.030000)	(0.03)
13	4.2	4.21		4.20	4.21		(0.010000)	(0.01)	MATCH
Sheet1

Cell Formulas
Range	Formula
D3:E13	D3	=ROUND(A3,2)
G3:G13	G3	=A3-B3
H3:H13	H3	=ROUND(G3,2)

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1				0.01
2	Field1	Field2
3	15.2654	15.27		Match
4	9.34108	9.34		Match
5	12.1128	12.1		Match
6	20.2	20.201		Match
7	4.699	5.34
8	18.4	18.4		Match
9	14.555	14.55		Match
10	10.25	14.6
11	11.1	9.86
12	16.4	16.43
13	4.2	4.21		Match
14
Main

Cell Formulas
Range	Formula
D3:D13	D3	=IF(ROUND(ABS(A3-B3),2)<=$D$1,"Match","")

 

[craigexcel]

Thanks for your reply, Fluff. That would work in what I would consider an interim solution. To be sure, though, I didn't adequately elaborate on what I'd like my 'summary to look like. I knew I'd overlook something.
Reattaching a revised snapshot, with just simple COUNTIF formulas in [K2:L3].
What I'm angling for, is the 'summary' in [K2:L3], without a column that finds which records are a match and which are not. Hope that is a bit more clear.

payroll matched values - COUNT by criteria.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	actual values			ROUNDed values (displayed with 2 dec places)			delta - actual values: Field1 vs Field2	delta - ROUNDed & displayed to 2 dec places
2	Field1	Field2		Field1	Field2						MATCH	2
3	15.2654	15.27		15.27	15.27		(0.004600)	-	no match		no match	9
4	9.34108	9.34		9.34	9.34		0.001080	-	no match
5	12.1128	12.1		12.11	12.10		0.012800	0.01	MATCH
6	20.2	20.201		20.20	20.20		(0.001000)	-	no match
7	4.699	5.34		4.70	5.34		(0.641000)	(0.64)	no match
8	18.4	18.4		18.40	18.40		-	-	no match
9	14.555	14.55		14.56	14.55		0.005000	-	no match
10	10.25	14.6		10.25	14.60		(4.350000)	(4.35)	no match
11	11.1	9.86		11.10	9.86		1.240000	1.24	no match
12	16.4	16.43		16.40	16.43		(0.030000)	(0.03)	no match
13	4.2	4.21		4.20	4.21		(0.010000)	(0.01)	MATCH
Sheet1

Cell Formulas
Range	Formula
D3:E13	D3	=ROUND(A3,2)
G3:G13	G3	=A3-B3
H3:H13	H3	=ROUND(G3,2)
L2	L2	=COUNTIF(I3:I13,"MATCH")
L3	L3	=COUNTIF(I3:I13,"no match")

 

[Fluff]

Why do you consider there are only 2 matches, when there are 8 that meet the criteria of less then or equal to .01 difference?

 

[craigexcel]

A fair (and accurate) point, tho I count only 7 (from the perspective of a $0.01 threshold; 8 matches @ <= $0.03). At any rate, attaching a modified snapshot.
And again, what I'm angling for is a 'summary' formula, that can do the match between the 2 fields, AND, then summarize (i.e. count) those cells in the range that are a match and those that are not.

payroll matched values - COUNT by criteria.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	actual values			ROUNDed values (displayed with 2 dec places)			delta - actual values: Field1 vs Field2	delta - ROUNDed & displayed to 2 dec places
2	Field1	Field2		Field1	Field2						MATCH	7
3	15.2654	15.27		15.27	15.27		(0.004600)	-	MATCH		no match	4
4	9.34108	9.34		9.34	9.34		0.001080	-	MATCH
5	12.1128	12.1		12.11	12.10		0.012800	0.01	MATCH
6	20.2	20.201		20.20	20.20		(0.001000)	-	MATCH
7	4.699	5.34		4.70	5.34		(0.641000)	(0.64)	no match
8	18.4	18.4		18.40	18.40		-	-	MATCH
9	14.555	14.55		14.56	14.55		0.005000	-	MATCH
10	10.25	14.6		10.25	14.60		(4.350000)	(4.35)	no match
11	11.1	9.86		11.10	9.86		1.240000	1.24	no match
12	16.4	16.43		16.40	16.43		(0.030000)	(0.03)	no match
13	4.2	4.21		4.20	4.21		(0.010000)	(0.01)	MATCH
Sheet1

Cell Formulas
Range	Formula
D3:E13	D3	=ROUND(A3,2)
G3:G13	G3	=A3-B3
H3:H13	H3	=ROUND(G3,2)
L2	L2	=COUNTIF(I3:I13,"MATCH")
L3	L3	=COUNTIF(I3:I13,"no match")

 

[bebo021999]

Try:

Vendor Bid Analys Summary (1).xlsm
	A	B	C	D	E
1			0.01
2
3	15.2654	15.27		MATCH	4
4	9.34108	9.34		No MATCH	1
5	12.1128	12.1
6	20.2	20.201
7	4.699	5.34
Sheet2

Cell Formulas
Range	Formula
E3	E3	=SUMPRODUCT(--(ABS(ROUND(A3:A7,2)-B3:B7)<=$C$1))
E4	E4	=COUNT(A3:A7)-E3

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[craigexcel]

bebo02199 -- Thanks for your reply, too. That did the trick.
Thanks again to Fluff for getting things started with your suggestion.
Appreciate both of your replies.
And Fluff, thanks for the reminder about updating my profile. Admittedly, I'm sure I'm behind on that, and since I haven't posted in some time, I did neglect to mention those details in my OP. Updating that next.

 

[Fluff]

Glad we could help & thanks for updating your profile.