Need help making a countif

[shivakanou]

Hello everybody!

I need help to tune my countif formula, it's something basic, but as it's not something taught by simple excel courses I'm a little bit lost.

I have a column (range C2:C288), where all the cells have the following formula:

=IF(COUNTIF(B:B;B2)=1;B2;"")

So it will look up the column and give me only the distinct values.
Now I need to make a countif to return me how many values are distinct.

Obs 1: I had to use this count if formula

=IF(COUNTIF(B:B;B2)=1;B2;"")

Because it was the only formula that returned the first distinct value, other formulas, like

=IF(A2="";"";IF(COUNTIF($A3:A288;A2)=1;A2;""))

Would return the last distinct, I don't know why.

Problem: As the "empty" cells still have a hidden formula, the formula

=COUNTIF($C2:$C288;"<>"&"")

Returns the total amount of cells (287)

Solution: Threat code cells as empty, but I don't know how Could you guys give me a hand? Thank you!

<tbody>
</tbody>

 

[Marcelo Branco]

Maybe...

=SUMPRODUCT(--(C2:C288<>""))

Hope this helps

M.

 

[shivakanou]

Maybe...

=SUMPRODUCT(--(C2:C288<>""))

Hope this helps

M.

Sorry to ask you this but, what doest <> means?

 

[sylwester.cz]

<> means "not equal to"