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!