I have a column like:
<colgroup><col></colgroup><tbody>
</tbody>
closed_cost_1_0.05_0.0_0.01_wordgrams |
f1 |
1 |
0 |
0.045454545 |
0 |
0 |
0 |
0 |
0 |
0.032258065 |
0 |
0 |
0.142857143 |
0.015267176 |
0 |
0.227272727 |
0.225806452 |
0 |
0.047619048 |
0 |
0 |
0.023529412 |
0.056338028 |
0 |
0 |
0 |
0 |
0 |
0.037735849 |
0 |
0 |
0 |
0.196428571 |
0.191780822 |
0 |
0 |
I want to average all these values if the second row is "f1" (sometimes it is "precision" or "recall"). I am trying =AVERAGEIFS(B4:B37,B2,"=f1") but it is getting a value error. Why? Also why is =AVERAGEIFS(B4:B37,B4:B37,"<>0",B2,"=f1") not working either? Thanks. |
<colgroup><col></colgroup><tbody>
</tbody>