This video explains how to use Count functions in LibreOffice Calc

The tutor explains how to use Count functions in LibreOffice calc. The tutor covers the COUNT, COUNTA, COUNTIF and COUNTIFS functions. The tutor starts off with the COUNT function and mentions that the COUNT function only counts numbers. The tutor then demonstrates the COUNTA function which counts both numbers and text. The tutor then moves on, to explain how to use the COUNTIF function. The tutor uses named ranges to enhance the demonstration. The final part of the video is the COUNTIFS function where the tutor counts two sets of criteria. This is a LibreOffice Calc tutorial covering, COUNT, COUNTA, COUNTIF, COUNTIFS and named ranges.
#libreofficecalc
If you want to support me, check this out: / itseasy
Playlists for this channel:
Access: • Unleash the POWER of S...
Excel: • Link web based data in...
Word: • How to use Microsoft W...
Visio: • How to create a basic ...
Project: • How to use Baselines a...
PowerPoint: • Zoom feature in Micros...
Publisher: • How to set or create B...
OneNote: • OneNote Overview, link...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv

[@ITsEasyTraining1st]

How to use the Count functions in LibreOffice. Check out courses at www.itseasy.co.uk

[@archhangell]

thanks a lot Boss!...highly appreciate you teaching a novice like me to make most out of my time on Libre Calc. Cheers!

[@ITsEasyTraining1st]

Glad to help!

[@pauls7056]

Great video. Thanks for posting.

[@ITsEasyTraining1st]

Thanks

[@EasyMSProject]

very good

[@ITsEasyTraining1st]

Thanks

[@grannysaxton9568]

Great

[@ITsEasyTraining1st]

Thanks

[@jeffbenedet8369]

love the help, but stuck (getting errors) on a countifs scenario. I think my error is 2 of the 3 ranges are looking for the same criteria? Help! Could I send you the practice file I am using? Need a count result in only 1 range but with an IF this OR that scenario first based on 2 other ranges...

[@jeffbenedet8369]

ahhh...nvm....discovered the "+" between the countifs !!!!!

[@ITsEasyTraining1st]

Great

[@EasyGoogle]

Cheap option

[@ITsEasyTraining1st]

Thanks