Hi all,
I'm trying to enter a Countif formula to add up the number of instances 'HL' appears in a number of cells across a row, but it keeps returning an error message, the error says i have used too many arguments for this function.
The formula i am trying to use is =COUNTIF(J3,R3,AA3,AJ3,AW3,BE3*"HL*")
<tbody>
</tbody>
This is driving me nuts, It should be really easy but i cant get it to work. Thank you. Emma
I'm trying to enter a Countif formula to add up the number of instances 'HL' appears in a number of cells across a row, but it keeps returning an error message, the error says i have used too many arguments for this function.
The formula i am trying to use is =COUNTIF(J3,R3,AA3,AJ3,AW3,BE3*"HL*")
i | J | R | AA | AJ | AW | BE | |
2 | Total number of HL | Option 1 (IB Group 1) | Option 2 (IB Group 2) | Option 3 (Mixed IB Group) | Option 4 (IB Group 4) | Option 5 (IB Group 5) | Option 6 (Mixed IB group) |
3 | =COUNTIF(J3,R3,AA3,AJ3,AW3,BE3*"HL*") This should return 3 | SL English | SL Spanish | Group 3: SL Business Management | HL Physics | HL Mathematics | Group 4: HL Chemistry |
4 | =COUNTIF(J4,R4,AA4,AJ4,AW4,BE4*"HL*") This should return 3 | SL English Language and Literature | SL French | Group 3: HL Psychology | HL Design & Technology | SL Mathematics | Group 4: HL Biology |
5 | SL English Language and Literature | HL Spanish | Group 3: SL Economics | HL Biology | SL Mathematics | Group 4: HL Chemistry |
<tbody>
</tbody>
This is driving me nuts, It should be really easy but i cant get it to work. Thank you. Emma