Can you tell us in plain words what do you want to do and provide a sample of
your data structure?

Regards,
Stefi

€žFiona Yorke-Saville€� ezt Ã*rta:

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