Hi,
try =SUMPRODUCT(1/COUNTIF(A1:C1,A1:C1)) if your values are in A1:C1
then fill down.
Ken Johnson
PS I think you meant 2 2 2 should return 1, if not then this is not the
solution you are after.