Hi Simple one I am sure -
Can anyone tell me why this formula results in #Value
=COUNTIFS(H17,"=DHL",M17:S17,"=*R*")
H I M N O P Q R S
<colgroup><col style="mso-width-source:userset;mso-width-alt:3913; width:80pt" span="2" width="107"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:1316; width:27pt" span="6" width="36"> </colgroup><tbody>
</tbody>
Any help
Can anyone tell me why this formula results in #Value
=COUNTIFS(H17,"=DHL",M17:S17,"=*R*")
H I M N O P Q R S
KNOWHOW CSC | KNOWHOW CSC | RS | |||||||
DHL | DHL | RS | RSC | RS | RS | RSC | RS | ||
KNOWHOW CSC | KNOWHOW CSC | RS | RS | RS | RS | RS | |||
KNOWHOW CSC | KNOWHOW CSC | RS | RS | RS | RS | RS | |||
KNOWHOW CSC | KNOWHOW CSC | RS | S | S | RS | ||||
DHL | DHL | RS | S | RSC | RS | ||||
DHL | DHL | RSC | RS | RS |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3913; width:80pt" span="2" width="107"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:1316; width:27pt" span="6" width="36"> </colgroup><tbody>
</tbody>
Any help