Calc 5.2.2.2 Error 504 when using function COUNTIF

congthan · October 30, 2016, 10:36am

Please anyone show me how to fix this. When I use the countif as syntax =COUNTIF($H$10:$H$110;"<=20/10/2016";$J$10:$J$110;“J10”), J10 is string of Text. The result is error 504. The same when i type the text string, like “Stay”.
Range H10:H110 are dates, J10:J110 are “Stay” or “Leave”.
I dont know that is enough info or not.
Tks in advance.
congthan

JohnSUN · October 30, 2016, 10:45am

Really COUNTIF()? Four parameters? Indeed?

mariosv · October 30, 2016, 11:34am

@JohnSUN is right, instead you should use COUNTIFS which can meet several parameters.

congthan · October 31, 2016, 1:47am

But it works with countif, due in my version of calc 5.2.2.2 now there’s no Countifs, really. And when I type COUNTIFS the result is #NAME?.

mariosv · November 11, 2016, 2:57pm

If the answer solves your question please tick the .

congthan · November 11, 2016, 2:30am

@JohnSUN & @mariosv COUNTIFS works well in this situation. My error due to failure somewhere in LiO install. Now it works well. Tks

Stanche · January 9, 2017, 10:14am

Please, can you tell me how exactly did you solved a problem?

congthan · November 11, 2016, 2:34am