I need to enter a formula in a cell in the "STATS" sheet that will count the number of unique dates in column G from the "DATA" sheet but ONLY IF column F contains the text, "JC".

F | G |

JC | 22/10/2017 |

JC | 22/10/2017 |

AF | 22/10/2017 |

BE | 17/10/2017 |

JC | 15/10/2015 |

JC | 14/10/2017 |

BE | 14/10/2017 |

BE | 12/10/2017 |

AF | 22/10/2017 |

<tbody>

</tbody>

So the formula should have the outcome of showing 3. as there are 3 unique dates that also have "JC" in column F.

Thanks in advance for you help. I have tried other formulas from other posts on this site and others but just can't seem to get to the correct outcome that I want.