case sensitivity using calc countif function [closed]

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 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

Sort by » oldest newest most voted

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

The solution is:

b3 =SUMPRODUCT(EXACT("A";A1:A2))
b4 =SUMPRODUCT(EXACT("a";A1:A2))

more

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

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

( 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!

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

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

more