countif/countifs ignoring blanks

[Fazila]

I need the percentages of values where it is greater than or equal to 0, however, for each column the value is different and to get the values I have used an index match formula so all cells have a formula which is causing the issues.

So far I have tried:

=countif(index(data,0,match(d1,heads,0)),">=0"/countif(index(data,0,match(d1,heads,0)),"<>")
=countif(index(data,0,match(d1,heads,0)),"<>")/countif(index(data,0,match(d1,heads,0)),"?*")
=countif(index(data,0,match(d1,heads,0)),"<>")/countif(index(data,0,match(d1,heads,0)),">""")

Unfortunately neither of these options work

It gets a bit more complicated that this then needs to be broken down into different categories so I would need a countifs formula:

=countif(countifs(gender,b5,index(data,0,match(d1,heads,0)),"<>")/countifs(gender,b5,index(data,0,match(d1,heads,0)),">""")

Any help would be very much appreciated.

Thanks

Fazila