Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters

preview_player
Показать описание

See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz at YouTube:
1. (00:10) Problem setup and review of last video Excel magic Trick
2. (00:53) COUNTIFS Function to count numbers with 4 or more characters. Raise 10 to a power and link it to a cell with the criteria 4.
3. (02:00) COUNTIFS Function to count text with 4 or more characters. Use REPT function with wildcards ? and *.
4. (04:35) Wild Cards for text strings: A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Excel wild card characters ? and * for text only? Yes, this information was not in the F1 Help for COUNTIFS, but instead it was in the F1 Help for the MATCH function.

formula from Bill Szysz at YouTube
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:04:59

Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters

Excel Magic Trick 0:06:57

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Excel Magic Trick 0:05:48

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Excel Magic Trick 0:07:14

Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?

Excel Magic Trick 0:05:58

Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

#142 | Countifs 0:00:41

#142 | Countifs function in Ms Excel #countifs #tricks

Learn Excel - 0:19:42

Learn Excel - Video 182 - Use of Wild Characters in CountIF -SumIF functions

Excel COUNTIFS & 0:11:20

Excel COUNTIFS & SUMIFS using Wildcards * and ?

Countif to see 0:02:24

Countif to see if two criteria match

Excel Countif with 0:10:02

Excel Countif with Wildcard

Excel Magic Trick 0:04:23

Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula

Countif Formula In 0:00:26

Countif Formula In Excel || find the count of 3 letter word in excel

Excel Magic Trick 0:02:49

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Excel Magic Trick 0:09:53

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Countif Logic with 0:09:37

Countif Logic with real data practice - Excel 2010 / 2013

Beginners Must Know! 0:00:26

Beginners Must Know! Wildcard with countifs | Pro Tip #excel #countifs #exceltraining

SUMIFS Function: Adding 1:09:15

SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978

Get Last 5 0:05:03

Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.

Excel Magic Trick 0:02:27

Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions

CountIF Advance Excel 0:06:54

CountIF Advance Excel Functions

How to use 0:15:14

How to use Wildcards within COUNTIF function in Excel #wildcards #excel, #functions

Excel Magic Trick 0:05:23

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTabl...

Excel Magic Trick 0:08:22

Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter

How to Use 0:04:36

How to Use Wildcard Characters in Excel with Countif Function - By Jeewan Sir

Комментарии
Автор

I like this! Much thanks to Bill Szysz, and ExcelIsFun for sharing the knowledge.
I'm looking for more opportunities to use wildcards like this.

OzduSoleilDATA
Автор

Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters
See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz at YouTube:
1. (00:10) Problem setup and review of last video Excel magic Trick
2. (00:53) COUNTIFS Function to count numbers with 4 or more characters. Raise 10 to a power and link it to a cell with the criteria 4.
3. (02:00) COUNTIFS Function to count text with 4 or more characters. Use REPT function with wildcards ? and *.
4. (04:35) Wild Cards for text strings: A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

formula from Bill Szysz at YouTube

excelisfun
Автор

Thanks Mike for an EXCELlent explanation :-))
Thanks guys for your kind words :-)

BillSzysz
Автор

Great tricks. Bill throws smart solutions "just like this" :)

pmsocho
Автор

Hello Mike,
I'd like to create cells in column A:
A1= X20
A2= X25 (every other 5 rows)
A3= X30...
please advise formula in cells A1, 2, 3....
(or in which trick#?)
Thank you.

tnguyen
Автор

That's weird that wildcards don't count numbers.  I would think a character is a character.  Maybe skip over spaces, but, even that seems questionable to me.

TimSheets