Seeking help to write a formula for the following data
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>
for the block A1:F8
count the number of times the number "1" occurs
IF the Row is "0" (zero) in Column H
Thank you, Garry
Col A | Col B | Col C | Col D | Col E | Col F | Col G | Col H | |
Row 1 | 42 | 45 | 17 | 15 | 24 | 18 | 0 | |
Row 2 | 21 | 32 | 35 | 9 | 30 | 27 | 1 | |
Row 3 | 14 | 24 | 44 | 22 | 12 | 20 | 1 | |
Row 4 | 33 | 25 | 5 | 34 | 30 | 19 | 0 | |
Row 5 | 29 | 43 | 5 | 13 | 32 | 1 | 0 | |
Row 6 | 19 | 18 | 6 | 10 | 32 | 36 | 0 | |
Row 7 | 24 | 11 | 22 | 26 | 33 | 18 | 1 | |
Row 8 | 25 | 44 | 41 | 1 | 11 | 22 | 1 |
<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>
for the block A1:F8
count the number of times the number "1" occurs
IF the Row is "0" (zero) in Column H
Thank you, Garry