What Will I Learn?
- How to find a total price using SUM formula on calc spreedsheet
- How to find a total price on one kind of product using SUMIFS
- How to find a average price on one kind type also one product using AVERAGEIFS
Requirements
System Requirements
No special requirements.OS Support
Microsoft Windows (IA-32 and x86-64),
Linux (IA-32 and x86-64) and macOS (x86-64).Requirements
Program Install Support: Install and Uninstall
The step picture
its for first step
second step: formula(drag price,drag product,product) dont forget about coma
third step
Difficulty
Either choose between the following options:
- Intermediate
Description
LibreOffice is the open source office software for word processing, spreadsheets, presentations, graphics design, databases and math. It can be downloaded and used completely free for any purpose. In this video below, I describe tools of calc spreedsheet LibreOffice and use intermediate formula (SUMIFS, AVERAGEIFS and COUNTIFS formulas) to help you with find value. The tools we'll be using are listed above, in this video What We Can Learn!
Video Tutorial
Curriculum
- https://utopian.io/utopian-io/@hansconan/tutorial-using-3-formula-on-calc-spreedsheet-libreoffice
- https://utopian.io/utopian-io/@hansconan/tutorial-video-libreoffice-calc-spreedsheet-using-forecast-power-and-formulatext-formulas
- https://utopian.io/utopian-io/@hansconan/libreoffice-tutorial-how-to-find-value-with-3-formulas-vlookup-hlookup-and-sum-formulas-on-libreoffice-calc-spreedsheet
Posted on Utopian.io - Rewarding Open Source Contributors
@hansconan, the concepts covered in your contribution are too simple. Use of these formula is covered in many other text and video tutorials around the Internet.
GUIDELINE -
Tutorials containing process videos, such as gameplay, content creation and simple on-screen instruction will be rejected.
Tutorials containing substantial instruction in ubiquitous functions (Save, Open, Print, etc.) or basic programming concepts (variables, operators, loops, etc.) will be rejected.
Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.
[utopian-moderator]