1.Count name beginning with `x`
I want to count all the name beginning with `x`.
2. count all blank cells
[Solved] Count cells beginning with x; Count empty cells
[Solved] Count cells beginning with x; Count empty cells
Last edited by MrProgrammer on Mon Oct 30, 2023 6:06 pm, edited 3 times in total.
Reason: Edited topic's subject
Reason: Edited topic's subject
LibreOffice 4.3.3.2 on Debian 8
Re: How to use contif in openoffice?
This formula works for me to count the names that begin with x
and this works too
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
=COUNTIF(A2:A12;"x[0-9]+")
Code: Select all
=COUNTIF(A2:A12;"^x.*")
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.