We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

COUNTIFS not working as supposed [closed]

asked 2016-12-13 16:59:30 +0200

lost1 gravatar image


I am using the following formula to count the occurrence of any combination of String1 and String2:


The formula doesn't correctly calculate the occurrences of String1 though. The String1 is "Abgeschlossen (ohne Erfolg)"

Using the same formula in Excel works.

I've uploaded a sample file here: https://drive.google.com/open?id=0Bw8XHs0yMt_PdFBxQXNxdlFSTjQt

Look at line 68. In column D it should say 1.

Excel correctly represents this.

Thank you

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 2020-09-16 15:53:07.577294

1 Answer

Sort by » oldest newest most voted

answered 2016-12-13 18:05:48 +0200

karolus gravatar image

simplified to:

=COUNTIF(B51:C51;"Nicht abgeschlossen|Abgeschlossen \(ohne Erfolg\)")

enable →Extras→Optionen→Calc→Berechnen→Reguläre Ausdrücke erlauben

edit flag offensive delete link more


Thank you for your answer! This works perfectly in Calc now. Do you maybe now a solution to make it compatible with Excel? Excel doesn't correctly evaluate the regex formula.

lost1 gravatar imagelost1 ( 2017-01-10 11:58:16 +0200 )edit

Question Tools

1 follower


Asked: 2016-12-13 16:59:30 +0200

Seen: 445 times

Last updated: Dec 13 '16