Finding the count of a given value

[karthick87]

I have an excel data like what you see in the attached excel workbook (containing two sheets). One is "raw_data" and the other one is "expected_output" is what I wanted to make.

Raw_Data contains rows and columns, each cell in a row against each cell in a column has a value in it. I would like to get the count of value which is greater than 0.79 for each row.

So for example, if we look at Row0 (A2) in the raw_data sheet it has two values that are greater than equal to 0.79 so the count is 2. I wanted to write the count for all the rows in the second sheet (like you see the results in expected_output).

Any help would be appreciated!

 

[rahulshewale1]

Hii @karthick87,

Try below formala in

=COUNTIF(raw_data!B2:G2,">="&0.79)

 

[rahulshewale1]

hii@karthick87,

Revised formula.
=COUNTIFS(OFFSET(raw_data!$A$1,MATCH(expected_ouput!$A2,raw_data!$A$2:$A$7,0),1,1,COUNTA(raw_data!$A$1:$K$1)),">="&0.79)



Regard
Rahul shewale

 

[bosco_yip]

Or……….

In C2, copied down

=COUNTIF(INDEX(raw_data!B$2:G$7,MATCH(A2,raw_data!A$2:A$7,0),0),">="&0.79)

Regards
Bosco

 

[karthick87]

Revised formula.
=COUNTIFS(OFFSET(raw_data!$A$1,MATCH(expected_ouput!$A2,raw_data!$A$2:$A$7,0),1,1,COUNTA(raw_data!$A$1:$K$1)),">="&0.79)

@rahulshewale1, could you please tell me the difference between the 1st formula and the above revised one?