That worked great!

Thanks,

Nick

"Daniel.M" wrote:

Hi,

The formula works well when counting numbers, but it returns #N/A when I try
to count text.

=SUM(IF(SUBTOTAL(3,OFFSET(A2,ROW(A2:A20)-ROW(A2),,1)),--(MMULT((A2:A20=TRANSPOSE
(A2:A20))*TRANSPOSE(SUBTOTAL(3,OFFSET(A2,ROW(A2:A2 0)-ROW(A2),,1)))*(ROW(A2:A20)
=TRANSPOSE(ROW(A2:A20))),ROW(A2:A20)^0)=1)))

Regards,

Daniel M.