Hi,

Does anyone know how I can add
=COUNTIF(B19:B21=A9)

in to the following formula:-
=SUMPRODUCT(1/COUNTIF(E19:E23,E19:E23&""))

I want it to do both things at the same time but cannot work out where/how
to put it???

Thanks
Fiona