Apache OpenOffice - Tutorial How to use count, counta, and countif formulas, and how to use them in a variety of ways
Hello everyone, Here I am share about my course curriculum about How to use the formula Count, Counta, Countif in finding data delivery of goods on OpenOffice
Tutorial : Apache OpenOffice Tutorial How to use count, counta, and countif formulas, and how to use them in a variety of ways
Video : Indonesian Language
Github : https://github.com/apache/openoffice
Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information
What Will I Learn?
In the video I gave an explanation how to create formulas math in OpenOffice, and the tools I describe below.
- How to use Count formula
- How to use Counta formula
- How to use Countif formula
- Difference of formula SUM & Count in finding amount
- Using 2 countif formulas at the same time
- How to use the countif formula to find 2 different objects
- How to use the countif formula by searching other than the object
Requirements
- System Requirements
Program Install Support: Install and Uninstall - System Requirements
No special requirements. - OS Support
Windows (XP, 2003, Vista, 7, 8 and 10)
GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions)
Mac OS X (x86-64 only)
Information
- Website & Download: https://www.openoffice.org/
- Type : Office suite software
- License : Dual-licensed under the SISSL and GNU LGPL
- Operating System : Linux, OS X, Microsoft Windows, Solaris
- Platform : IA-32, x86-64, PowerPC, SPARC
Read more - Wikipedia
My Operating System
Difficulty
- Intermediate
Description
Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, Here I explain by using the formula COUNT, COUNTA, and COUNTIF in searching data delivery of goods. The tools we'll be using are listed above, in the What We Can Learn!
Video Tutorial
Curriculum
If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :
- Apache OpenOffice - Tutorial creates tables with basic formulas (Spreadsheet)
- Apache OpenOffice - Tutorial creates tables with VLOOKUP, HLOOKUP, and SUM formulas (Spreadsheet)
- Apache OpenOffice - Tutorial creates Table & Form in Database
- Apache OpenOffice - Tutorial creates Presentation slide
- Apache OpenOffice - Tutorial creates tables with IF AND & IF OR formulas
- Apache OpenOffice - Tutorial creates tables with IF LEFT, IF MID & IF RIGHT formulas
- Apache OpenOffice - Tutorial creates Report on Database
- Apache OpenOffice - Tutorial to use and Differences on formulas Min/Max & Large/Small, as well as how easy to use them with name box
- Apache OpenOffice - Tutorial create a math formula in OpenOffice
Author : @Darsondrew
Utopian-io Comunicate with me in
Discord Utopian.io https://discordapp.com/channels/371714299544207360/371714300269690881
Posted on Utopian.io - Rewarding Open Source Contributors
@darsondrew, I always try to support who contribute to open source project, upvote you.
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Hey @darsondrew I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x