Hi Bob,

That one is perfectly OK ... though for a set of conditions?

I would like to avoid to write a formula like:
=SUMPRODUCT(--(ISNUMBER(FIND(A1,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A2,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A3,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A3,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A4,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A5,G1:G20))))
+SUMPRODUCT(--(ISNUMBER(FIND(A6,G1:G20)))) +...


I might have like 20-25 conditions ...
Best Regards, Sige