Hi,
I now how to count cells that contain certain numbers in a range but how do i count if a number appears in a certain selection of cells.
In the example below each there are 4 repeating columns.
I would want to count how many time a 7 appears in each column with the title "C" which would give the answer 2.
Is this possible to Achieve?
<colgroup><col span="16"></colgroup><tbody>
</tbody>
Many Thanks
I now how to count cells that contain certain numbers in a range but how do i count if a number appears in a certain selection of cells.
In the example below each there are 4 repeating columns.
I would want to count how many time a 7 appears in each column with the title "C" which would give the answer 2.
Is this possible to Achieve?
A | B | C | D | A | B | C | D | A | B | C | D | A | B | C | D |
1 | 7 | 5 | 1 | 1 | 5 | 7 | 0 | 1 | 1 | 7 | 0 | 7 | 1 | 4 | 2 |
<colgroup><col span="16"></colgroup><tbody>
</tbody>
Many Thanks