Ask Your Question

Calc Error 504 when using function COUNTIF [closed]

asked 2016-10-30 11:36:16 +0200

congthan gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by congthan
close date 2016-11-11 03:34:17.519381


Really COUNTIF()? Four parameters? Indeed?

JohnSUN gravatar imageJohnSUN ( 2016-10-30 11:45:54 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-10-30 12:34:39 +0200

m.a.riosv gravatar image

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

edit flag offensive delete link more


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

congthan gravatar imagecongthan ( 2016-10-31 02:47:23 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-11-11 15:57:20 +0200 )edit

answered 2016-11-11 03:30:27 +0200

congthan gravatar image

updated 2016-11-11 03:33:05 +0200

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

edit flag offensive delete link more


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

Stanche gravatar imageStanche ( 2017-01-09 11:14:34 +0200 )edit

Question Tools

1 follower


Asked: 2016-10-30 11:36:16 +0200

Seen: 778 times

Last updated: Nov 11 '16