Ask Your Question
1

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

asked 2014-07-08 09:08:26 +0100

InfamousBlob gravatar image

updated 2015-09-01 23:01:42 +0100

Alex Kemp gravatar image

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)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 22:00:05.842149

Comments

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 gravatar imageRegina ( 2014-07-08 12:09:32 +0100 )edit

@Regina, I have fixed the formatting.

oweng gravatar imageoweng ( 2014-07-08 12:35:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted
4

answered 2014-07-08 12:00:56 +0100

Regina gravatar image

A criterion has the data type "string". Only expressions, which result in a single number value are converted automatically. Therefore you need to write =COUNTIFS($A$2:$A$407;">"&F1;$A$2:$A$407;"<="&F2) (my parameter delimiter is ;). The number values in F1 and F2 are automatically converted to string when they a concatenated to a string using &. The application help has some examples with correct syntax in the help for COUNTIF.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-07-08 09:08:26 +0100

Seen: 11,724 times

Last updated: Jul 08 '14