Calc

Calc is the spreadsheet program you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.

• Project Homepage [EN]

• Calc [EN] @ Wikipedia

Documentation

• Shortcuts [EN]

Examples

Counting unique values

Replace DATA with the corresponding data range e.g. A1:A100

=SUMPRODUCT((DATA<>"")/(COUNTIF(DATA;DATA)+(DATA="")))