Hello
I have a table similar to the one below:
<tbody>
</tbody>
I need to count the number of bs, ds, s' and ms in all the columns headed with ...Teacher Assessment.
The formula I have tried to use so far is =SUM(COUNTIF(INDEX(RawData,0,MATCH("*teacher assessment*",RawDataHeadings,0)),{"b-";"s1";"s2";"s3";"b-1";"b-2";"b-3"})) (the bit in bold highlights the many variations I need to count but only for this column).
For the other columns it will be simply B, B+, D- etch.
The result it is returning is 2 - the result should be well over 200.
Any ideas as to where I am going wrong?
Thanks
I have a table similar to the one below:
English Teacher | English Teacher Target | English Teacher Assessment | Maths Teacher | Maths Teacher Target | Maths Teacher Assessment | Science Teacher | Science Teacher Target | Science Teacher Assessment | |
a | b | b- | e | d | d | i | s | s+ | |
b | d | b | f | s | d+ | j | m | m- | |
c | s | b+ | g | m | s- | k | b | b | |
d | m | d- | h | b | s+ | l | d | b+ |
<tbody>
</tbody>
I need to count the number of bs, ds, s' and ms in all the columns headed with ...Teacher Assessment.
The formula I have tried to use so far is =SUM(COUNTIF(INDEX(RawData,0,MATCH("*teacher assessment*",RawDataHeadings,0)),{"b-";"s1";"s2";"s3";"b-1";"b-2";"b-3"})) (the bit in bold highlights the many variations I need to count but only for this column).
For the other columns it will be simply B, B+, D- etch.
The result it is returning is 2 - the result should be well over 200.
Any ideas as to where I am going wrong?
Thanks