how to count distinct values in a column and grouping them like a pivot table

[Anonymous]

Hi experts,

Would you know how I can count distinct values in a column and grouping them like a pivot table, for example:

Black 10
Red 12
Blue 08
White 24

Cheers,

Gilly

[dilumd · Accepted solution]

Hi

You want sum of distinct values? Use COUNTRAWS function