COUNT, COUNTIF, COUNTIFS functions in Google Sheets

COUNT, COUNTIF, COUNTIFS functions in Google Sheets

70.655 Lượt nghe
COUNT, COUNTIF, COUNTIFS functions in Google Sheets
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-countifs/ 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