I want non-cumulative frequency

[pytty]

I’m testing my self made dice. I tally up the results of different results and I want Calc to show the frequencies of the different results. I’m a Calc noob, but I imagine this should be a simple task. I have googled how to use FREQUENCY(), but I seem to get cumulative frequency of the results, for some reason.

If I have this data (in Column A):

6, 3, 1, 2, 2, 2, 5, 1, 1, 2, 2, 6, 3, 2, 5, 2, 5, 4, 5, 3

I write this formula:

=FREQ(A:A; 1), =FREQ(A:A; 2), ...

I want this result:

1   3
2   7
3   3
4   1
5   4
6   2

But what I get is:

1   3
2   10
3   13
4   14
5   18
6   20

Why? Am I using a wrong formula or what?

[JohnSUN]

What about =FREQUENCY(A:A;{1;2;3;4;5})?

[anon73440385]

You seem to look for:

=COUNTIF(A:A; "=1" )
=COUNTIF(A:A; "=2" )
…

[dscheikey]

Hi pytty,

please use all the clues in one cell and use the function as a matrix function. So finish with Ctrl + Shift + Enter.

This is how it should work: `{=FREQUENCY(A1:A20,{1,2,3,4,5})}´

Frequency.ods