# What is wrong with this Calc function?

5 replies to this topic

### #1 Man

Man

Chief Above Chief Member

• Normal Members
• 258 posts
• Gender:Male
• Location:Earth
• Interests:- Fookin' with da knobs since 1991
- Horror movies
- Mr. Robot
- Trailer Park Boys

Posted 17 September 2017 - 01:16

It's in OpenOffice ;

```=COUNTIF(A2:A6;"=ab*")
=COUNTIF(A2:A6;"ab*")
```

I want to count the number of occurences of text that starts with "ab"  in rows A2 to A6.

Both don't work.

Probably something stupid but I am stupid so I don't get it.

Grrr

And my favourite colour is black.

Edited by Man, 17 September 2017 - 01:16.

### #2 dblue

dblue

Dodgy Geezer

• 5815 posts
• Gender:Male
• Location:Berlin
• Interests:Code. Music. Graphics.

Posted 17 September 2017 - 19:41

I believe your function would work in Excel, but OpenOffice uses a slightly different syntax.

`=COUNTIF(A2:A6; "ab.*")`
.

Similarly, to count all cells ending "yz" you'd use:

`=COUNTIF(A2:A6; ".*yz")`

### #3 TheBellows

TheBellows

Guruh Motha Fakka is Levitating and Knows Everything About Renoise Member

• Normal Members
• 2560 posts
• Gender:Male
• Location:Oslo, Norway
• Interests:Jepp

Posted 17 September 2017 - 19:59

• oneunkind likes this

### #4 Man

Man

Chief Above Chief Member

• Normal Members
• 258 posts
• Gender:Male
• Location:Earth
• Interests:- Fookin' with da knobs since 1991
- Horror movies
- Mr. Robot
- Trailer Park Boys

Posted 17 September 2017 - 23:22

```= COUNTIF(A1:A1000; ".*jeux")
```

This doesn't work, it still returns 0.

Oh and is ) a special character?

### #5 TheBellows

TheBellows

Guruh Motha Fakka is Levitating and Knows Everything About Renoise Member

• Normal Members
• 2560 posts
• Gender:Male
• Location:Oslo, Norway
• Interests:Jepp

Posted 21 September 2017 - 14:52

Completely off topic: I don't know what's going on these days, when i write a post in the quick reply editor and press post, it shows up as an empty post. It happened on another forum as well, i really don't know whats going on?

I have to copy the text every time now and re-edit the post and paste it back in. This is incredibly annoying, anyone an idea what's going on?

This is why the post above is blank. It was just a bad cat joke anyway.

Edited by TheBellows, 21 September 2017 - 14:56.

### #6 Man

Man

Chief Above Chief Member

• Normal Members
• 258 posts
• Gender:Male
• Location:Earth
• Interests:- Fookin' with da knobs since 1991
- Horror movies
- Mr. Robot
- Trailer Park Boys

Posted 25 September 2017 - 00:16

Help says it should just be * for 0 or more characters, so i guess it's a bug.  Where's my bug-swatter, damn things are everywhere!

https://www.amazon.c...&qid=1506294881

Come back you!

In other words, I give up.