hi smwbuddy, welcome to the forum. try this array formula:
=SUM(IF(FREQUENCY(IF($B$2:$B$26=$F2,IF($C$2:$C$26=G$1,IF($B$2:$B$26<>"",MATCH($A$2:$A$26,$A$2:$A$26,0)))),ROW($A$2:$A$26)-ROW($A$2)+1),1))
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again. extend range as you desired