=COUNTIF(A1:A100,"distinct")

"Guilherme Loretti" wrote:

Hello. Please, is there some formula i can use to do count distinct of a
range of cells? This would help to eliminate duplicates when counting, I can
do this using the pivot table but it would be great to have this as formula
to avoid many steps. Thanks