On Jan 2, 9:19*am, Spiky wrote:
I think this is what you want, although you should get rid of the
Subtotals first:
=COUNTA($C$1:$C$10)-SUMPRODUCT(--($A$1:$A$10=$C$1:$C$10))

Not sure if you want Count or CountA, depends on your data.

Should have mentioned....this formula applies to your original layout
with 3 columns, not the one with 5 columns.