How can I calculate "How many entries" in table

[rajeshn_in]

Hi friends,

I have a table from A : C
How can I calculate "How many entries" made in table.

I want that number in F1.
Please see attachment for better understanding.

[Ghozi Alkatiri]

=sumproduct(1/countif($b$2:$b$11;$b$2:$b$11))

[rajeshn_in]

Hi Ghozi Alkatiri ,

Some thing is wrong, with above formula I am getting error. and with "=sumproduct(1/countif($b$2:$b$11, $b$2:$b$11))" formula I am getting '2'.

[JohnTopley]

Is this what you want ?

=COUNT(C2:C28)

The formula supplied by Ghozi counts UNIQUE entries.

[rajeshn_in]

Thank you John Topley & Ghozi Alkatiri