i’m creating a log to record replaced ropes at a climbing gym, with various “averages” output for overview.

i’d like to add an option to filter these “averages” by rope type, selected in a drop-down.

i already have the “averages” displayed using COUNTIFS with two criteria, and it works perfectly.

but when i add this drop-down match criteria (3rd criteria using COUNTIF), i can’t seem to make the formula work. adding this 3rd criteria gives faulty output (currently “0”, when it should display “1”)

i highlighted pertinent cells in turquois. hoping for a simple solution/explanation.

attached file.

i tried adding 3rd criteria to COUNTIFS but it doesn’t work.