We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

case sensitivity using calc countif function [closed]

asked 2014-05-15 15:57:25 +0200

usacoder gravatar image

updated 2014-05-15 15:57:50 +0200

Docs say to go to Tools->Options->LibreOffice Calc->Calculate and check 'Case Sensitive'. I've done; and actually it was already set.

I tried "enable regular expressions..." too; same results.

a1 = a

a2 = A

b3 = countif(a1:a2, "A") returns 2

b4 = countif(a1:a2, "a") returns 2

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-23 02:12:28.956518

2 Answers

Sort by » oldest newest most voted

answered 2014-05-15 17:44:05 +0200

Pedro gravatar image

updated 2014-05-15 17:45:51 +0200

The answer is: COUNTIF is not case sensitive (it's not case sensitive in Excel either)

The solution is:


Source : https://uk.answers.yahoo.com/question...

edit flag offensive delete link more


Excel's solution is wildcards! If.. A1 = CAR A2 = Car A3 = car

The solution is 3 using the formula: =COUNTIF(A1:A3,"*car*")

Quixrhyno gravatar imageQuixrhyno ( 2018-10-18 21:17:34 +0200 )edit

In LibreOffice the double quotes "car" is all you need. My issue is when the word has other characters too!

Quixrhyno gravatar imageQuixrhyno ( 2018-10-18 21:22:04 +0200 )edit

answered 2014-05-17 15:20:07 +0200

usacoder gravatar image

hmmm... so the case sensitive checkbox is not universally used. that seems odd.

edit flag offensive delete link more


@usacoder, maybe that can be changed... You can always ask for an Enhancement request at https://www.libreoffice.org/get-help/... or at https://bugs.freedesktop.org/enter_bu...

Pedro gravatar imagePedro ( 2014-05-17 16:57:38 +0200 )edit

Question Tools

1 follower


Asked: 2014-05-15 15:57:25 +0200

Seen: 2,379 times

Last updated: May 17 '14