countifs, match and index with variable criteria

[cjcass]

Hi,
I have the following formula which works fine (refers to pic below) =COUNTIFS(INDEX(B4:H25,0,MATCH(J8,B3:H3,0)),K8,INDEX(B4:H25,0,MATCH(J9,B3:H3,0)),K9)
In its current format the formula reads cells K8 & K9 as fixed values but I want to be able to use > >= < etc. on these values. The best option would be to put these symbols into the cells directly, so for example K8 could change from '6' to '>6'. How could I adapt/change the formula so it calculates accordingly?
Many thanks.

 

[Marcelo Branco]

Is not possible to copy your data for testing purposes from a picture. Try to post a useful data sample - try copy from your worksheet and paste in a forum reply page.
Also, could you provide examples using the symbols > or < along with the expected results?

M.

 

[cjcass]

please ignore this thread - it calculates anyway with the symbols directly typed into the cell!!! dunno why it didn't work when I trailled it??