Ask Your Question
1

case sensitivity using calc countif function [closed]

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

usacoder gravatar image

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

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
2

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

Pedro gravatar image

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

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

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

edit flag offensive delete link more

Comments

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 +0100 )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 +0100 )edit
0

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

usacoder gravatar image

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

edit flag offensive delete link more

Comments

@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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 1,423 times

Last updated: May 17 '14