[Solved] Count cells beginning with x; Count empty cells

Discuss the spreadsheet application
Post Reply
luofeiyu
Posts: 21
Joined: Thu Sep 14, 2017 2:11 am

[Solved] Count cells beginning with x; Count empty cells

Post by luofeiyu »

1.Count name beginning with `x`
I want to count all the name beginning with `x`.
beginning-with-x.png
2. count all blank cells
blank.png
Last edited by MrProgrammer on Mon Oct 30, 2023 6:06 pm, edited 3 times in total.
Reason: Edited topic's subject
LibreOffice 4.3.3.2 on Debian 8
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to use contif in openoffice?

Post by FJCC »

This formula works for me to count the names that begin with x

Code: Select all

=COUNTIF(A2:A12;"x[0-9]+")
and this works too

Code: Select all

=COUNTIF(A2:A12;"^x.*")
Try going to the menu Tools -> Options, expand the OpenOffice Calc list on the left, select calculate and check the box for Enable Regular Expressions in Formulas.

For counting blanks, use the SUMPRODUCT() function

Code: Select all

=SUMPRODUCT(ISBLANK(A2:A12))
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply