# LibreOffice Calc: Error 510, what's wrong with this formula? [closed]

Hi guys, 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

```
=COUNTIFS($A$2:$A$407,>F1,$A$2:$A$407,<=F2)
```

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 `<F1`

and `<=F2`

with `"<0"`

and `"<=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 :) Thanks

(Using LibreOffice 4.2.4.2 on Ubuntu 14.04)

Your text after "It does ..." is unreadable for me. Try to write a grave accent before and after a formula to hide special characters like

`<`

to be interpreted as html tag, or write the formula into a separate line using the 1010-button of the editor, for example.@Regina, I have fixed the formatting.