Watch this Google Sheets tutorial to know all the ways of using the COUNT functions group - COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK, and COUNTUNIQUE.
❗Download your copy of practice sheet: http://bit.ly/rwcount-practice ❗
Today you will learn:
✅ how to count the number of cells that contain numbers or texts, and the blank ones
✅ how to count the cells that meet one or multiple criteria
✅ how to apply different conditions expressed in numbers and texts, including math operators (countif greater than, less than, equal, etc.) and wildcards.
📚Read a detailed article about the COUNTIF and COUNTIFS functions by Coupler.io: https://blog.coupler.io/countif-and-c...
Try Coupler.io to pull your data from various apps to Google Sheets on a set schedule: http://bit.ly/coupler-rwcount
Timestamps:
0:00 Intro
1:21 How to count cells with numeric values with COUNT function
4:21 How to count cells with any value with COUNTA function
4:50 How to count cells that meet a certain criterion with COUNTIF function
8:14 Count cells using wildcards (for countif contains or to set up a specific number of characters)
11:00 How to count cells that meet 1 or more criteria with COUNTIFS function
13:36 How to count cells that contain unique value with COUNTUNIQUE function
14:18 How to count blank cells with COUNTBLANK function

Watch our next video presenting IF function in Google Sheets.
Get your personal copy of Google Sheets practice file with Count functions tasks here: http://bit.ly/rwcount-practice

Design and video production: Oleg Gorovoi, Vlad Shagov
Cases: Anastasiia Avramenko, Natalia Gorovaia
Speaker: Natalia Gorovaia