Jump to content


Photo

What is wrong with this Calc function?


  • Please log in to reply
5 replies to this topic

#1 Man

Man

    Local Chief Member

  • Normal Members
  • PipPipPipPipPip
  • 208 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

  • Admins
  • PipPipPipPipPipPipPipPipPipPipPipPipPipPipPip
  • 5607 posts
  • Gender:Male
  • Location:Berlin
  • Interests:Code. Music. Graphics.

Posted 17 September 2017 - 19:41

You almost had it.

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

Try this instead:
 
=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
  • PipPipPipPipPipPipPipPipPipPipPipPipPip
  • 2379 posts
  • Gender:Male
  • Location:Oslo, Norway
  • Interests:Jepp

Posted 17 September 2017 - 19:59


  • oneunkind likes this

#4 Man

Man

    Local Chief Member

  • Normal Members
  • PipPipPipPipPip
  • 208 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
  • PipPipPipPipPipPipPipPipPipPipPipPipPip
  • 2379 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. :P


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


#6 Man

Man

    Local Chief Member

  • Normal Members
  • PipPipPipPipPip
  • 208 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. :P