Currently trying to categorise some data based upon whether or not it is greater than or equal to the value in column F.
This is the formula I’m using
So basically I’m aiming to count all occurrences of values greater than the figure in F1 and less than or equal to the figure in F2.
However it’s not working and I get error 510 every time.
It does however work if I replace
"<=365" which are the values in F1 and F2. As you can probably see, I’m working with length of time here and the values in column F are the number of days in 1 year, 2 years e.t.c. It’s a problem that’s pretty easy to workaround, just by placing the number in the formula as opposed to linking to the cell, but why it’s not working is a little beyond me.
I can imagine there’s going to be something remarkably obvious I’m missing…
All help appreciated
(Using LibreOffice 22.214.171.124 on Ubuntu 14.04)