COUNTIF Function in Excel for numbers, dates, and text by Chris Menard скачать в хорошем качестве

COUNTIF Function in Excel for numbers, dates, and text by Chris Menard

Blog Post with the file for downloading: https://chrismenardtraining.com/post/... One of the most powerful functions in Excel is the COUNTIF function. The COUNTIF function in Excel counts the number of cells that meet criteria you specify. Several examples of when to use COUNTIF: Timestamps: 01:10 Text - Two arguments - Range and Criteria 03:00 Wildcard search with COUNTIF 04:38 COUNTIF with Numbers - Purchases over 1000 06:08 COUNTIF with Dates Syntax =COUNTIF(Range, Criteria) The COUNTIF function has two arguments. Both arguments, range & criteria, are required. The criteria can be text, numbers or dates. Chris Menard's Website: https://chrismenardtraining.com And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!