Hello - I have been stuck on this formula for a few hours. It is the last one I need for this report.
Here is mycurrent formula:
=SUMPRODUCT((1/COUNTIF(CIF,CIF&""))*(--(LEFT(Officer,3)=D2)))
CIF = my rangename for each customer’s ID, which consists of three letters and four numbers...