Why do I have so much difficulty using the FREQUENCY formula consistently correct?

I know it is an array formula, I use control, shift, enter to enter the formula. But I so often struggle with getting it to work properly that is is often frustrating.

This formula is so central to statistical analysis, I use it often & I struggle to get it to work almost every time. What am I doing wrong and, more importantly, when it works, what am I doing correctly: if I knew that, I wouldn't ever have a problem.

I've read the Help on the MS site a million times. I need some plan English and a patient person with whom to dialogue/monologue.

Thanks,

SIL

I assume you are array entering the formula in a range. FREQUENCY always returns 1 more value than the number of bins so if you use a formula like this

=FREQUENCY(A1:A100,{0,10,20})

then that will return a 4 element array so it would normally be array entered in a 4 cell range. I do that like this:

Select a cell and paste/type the formula in
Now just select the 4 cell range starting with that cell (so if you put the formula in M2 you'd select M2:M5 for example)
Press F2 key to select
Hold down CTRL and SHIFT keys and press ENTER

You will now see the formula (surrounded by curly braces like { and }) in each cell and there will be a number in each cell