Indirect - CountIf including Match

[Dewplicate]

Hey all, Indirect formulas are burning a hole through my skull so looking for some assistance

I'm working on a table - to look up values in another "reference" table - based on values in the main worksheet
I'll put the background info in a box as it's probably not relevant

Titles (e.g. Splat) may move between columns in the main worksheet as well as rows in the reference worksheet so I need it to dynamically find the titles and count values in their rows

In the reference worksheet

R4 EV

table headers are rows 1-2 and data exists between B3 and AB25

B5 = Splat (example row header)
E5 = Rabbit (first value)
G5 = Rabbit (second value)
I5 = Rabbit (third value)

In the main worksheet:

F2 = Splat (example column header)
B3 = Rabbit (row header)

There may be other ways of doing this but I need a formula I can fix and I've used indirect before for referencing cells in other worksheets
​

The formula I'm looking to correct is:

​

="=COUNTIF('R4 EV'!$E"&MATCH(F$2,'R4 EV'!$B$3:$B$25,0)+2&":$AB"&MATCH(F2,'R4 EV'!$B$3:$B$25,0)+2&",$B3)"

This currently returns =COUNTIF('R4 EV'!$E5:$AB5,$B3) which is right but I want it to execute the formula

Could someone please assist with the Indirect() to get this to run?​

 

[Dewplicate]

Apologies for the tragic formatting, it looked correct in preview