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



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

 

[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.