![]() ![]() ![]() Using formulas and cell references in Ten concepts that every Calc user should know if you don't understand why there are two $ characters in =1/COUNTIF(X$2:X$12 X2). Most people find this method much easier to understand. Instead put =1/COUNTIF(X$2:X$12 X2) in Y2, fill the formula down to Y12, and sum those values with =SUM(Y2:Y12). If you don't understand the array formula, don't use it. ![]() Numbers which occur once contribute one 1/1, numbers which occur twice contribute two 1/2's, numbers which occur thrice contribute three 1/3's, etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |