Count cells with text, COUNTIF function and wildcards | Excel Tips #31
In this video about Excel you will see how to count cells with text using COUNTIF function and wildcards. Excel Tips #31
Formulas used in this video:
=COUNTIF($B$2:$B$11,"*")
=COUNTIF($B$2:$B$11,"?*")
=COUNTA(B2:B11)
Excel SuperHero book: https://www.amazon.com/dp/B0B49CRTV6
00:00 | Intro
00:09 | Count all cells with text, even empty text string
01:20 | Count cells with text that has at least one sign
01:52 | Count not empty cells COUNTIF and COUNTA functions
02:15 | Ending
#excel #COUNTIF #wildcard #wildcards #COUNTA #text
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube