I have been struggling with a hit-up in Calc that might be of my own making (admittedly). I've been trying to do a frequency distribution, but each time that I try to use the function button, and start the process, I get an error message: #VALUE!

I engage the formula function by applying FUNCTION under the all spread and then click next. After this, I highlight the column for the data selection, then I highlight the other column of bin parameters that I created [see attachment].

I then make sure Array is checked and click Okay.

Then I get the #VALUE! error message.

Any help getting my frequency distribution up and running would be appreciated.

Thanks!

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].. Was asking for expertise