excel 2003 Countif 3 to 4 criteria

[DerekWooley]

Hello, I am trying to rank my items in the below table in excel 2003 so I can't use countifs. I want to rank the items by quarter (Column E), then by month (Column F), then by material and size. the below formula I am using works for 2 criteria but I need to add 2 more.

Formula that works for 2 criteria:
=(COUNTIF($E$3:$E$45,"<"&E3)&"."&COUNTIF($F$3:$F$45,"<"&F3))*1

I thought about using the below formula to add another criteria column but I get the #Value error.
=(COUNTIF($E$3:$E$45,"<"&E3)&"."&COUNTIF($F$3:$F$45,"<"&F3)&"."&COUNTIF($G$3:$G$45,"<"&G3))*1

A	B	C	D	E	F	G	H	J
Item	Actual Date	Quarter Text	Month Text	Quarter Value	Month Value	Material	Size	Ranking
222	8/11/2018	20183	20188	20183	20188	Brass	0.0625	1.20
666	11/26/2018	20184	201811	20184	201811	Brass	0.0625	4.33
341	5/10/2019	20192	20195	20192	20195	Brass	0.0625	13.90
408	8/14/2019	20193	20198	20193	20198	Brass	0.0625	19.16
106	11/10/2021	20214	202111	20214	202111	Brass	0.0625	38.41
58	12/2/2024	20244	202412	20244	202412	Brass	0.0625	42.42
472	12/2/2018	20184	201812	20184	201812	Brass	0.09375	4.36
454	1/24/2019	20191	20191	20191	20191	Brass	0.09375	10.40
504	7/12/2019	20193	20197	20193	20197	Brass	0.09375	19.13
5	6/8/2020	20202	20206	20202	20206	Brass	0.09375	29.23
865	4/6/2019	20192	20194	20192	20194	Poly	0.125	13.70
688	5/3/2019	20192	20195	20192	20195	Poly	0.125	13.90
770	12/22/2019	20194	201912	20194	201912	Poly	0.125	26.38
101	1/19/2020	20201	20201	20201	20201	Poly	0.125	28.20
17	10/8/2018	20184	201810	20184	201810	Plastic	0.1875	4.31
569	10/18/2018	20184	201810	20184	201810	Plastic	0.1875	4.31
801	7/5/2019	20193	20197	20193	20197	Plastic	0.1875	19.13
349	2/14/2022	20221	20222	20221	20222	Plastic	0.1875	39.28
248	11/8/2018	20184	201811	20184	201811	Brass	0.21875	4.33
53	11/10/2018	20184	201811	20184	201811	Brass	0.21875	4.33
353	6/16/2019	20192	20196	20192	20196	Brass	0.21875	13.12
847	4/6/2019	20192	20194	20192	20194	Brass	0.21875	13.70
221	7/17/2019	20193	20197	20193	20197	Brass	0.21875	19.13
194	8/4/2019	20193	20198	20193	20198	Brass	0.21875	19.16
927	8/10/2019	20193	20198	20193	20198	Brass	0.21875	19.16
436	8/18/2019	20193	20198	20193	20198	Brass	0.21875	19.16
672	10/20/2019	20194	201910	20194	201910	Brass	0.21875	26.37
5	5/2/2020	20202	20205	20202	20205	Brass	0.21875	29.21
311	6/26/2020	20202	20206	20202	20206	Brass	0.21875	29.23
14	7/7/2020	20203	20207	20203	20207	Brass	0.21875	33.25
251	2/14/2021	20211	20212	20211	20212	Brass	0.21875	36.26
386	4/5/2021	20212	20214	20212	20214	Brass	0.21875	37.27
171	8/21/2022	20223	20228	20223	20228	Brass	0.21875	40.29
349	9/6/2022	20223	20229	20223	20229	Brass	0.21875	40.30
901	5/28/2018	20182	20185	20182	20185	Hydex	0.25	0.00
458	5/25/2020	20202	20205	20202	20205	Hydex	0.25	29.21
128	5/18/2019	20192	20195	20192	20195	Paper	0.25	13.90
92	11/27/2020	20204	202011	20204	202011	Paper	0.25	34.39
167	8/17/2018	20183	20188	20183	20188	Plastic	0.25	1.20
854	2/5/2019	20191	20192	20191	20192	Plastic	0.25	10.60
886	7/20/2018	20183	20187	20183	20187	Wood	0.25	1.10
394	1/7/2019	20191	20191	20191	20191	Wood	0.25	10.40
418	11/11/2020	20204	202011	20204	202011	Wood	0.25	34.39
604	4/26/2025	20252	20254	20252	20254	Wood	0.25	43.31

<colgroup><col><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

This appears to be a Duplicate/Continuation of: https://www.mrexcel.com/forum/excel-questions/1054179-excel-2003-countifs.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.