We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

InfamousBlob's profile - activity

2019-04-15 11:55:11 +0200 received badge  Student (source)
2014-07-12 03:29:16 +0200 received badge  Famous Question (source)
2014-07-08 14:27:55 +0200 received badge  Notable Question (source)
2014-07-08 11:58:27 +0200 received badge  Popular Question (source)
2014-07-08 09:09:06 +0200 received badge  Editor (source)
2014-07-08 09:08:26 +0200 asked a question LibreOffice Calc: Error 510, what's wrong with this formula?

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)