countif/countifs ignoring blanks

Fazila

Board Regular
Joined
Nov 19, 2014
Messages
163
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
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top