Excel Magic Trick 1047: 'Number 225', & 'Text 225.00' Same For COUNTIF, SUMIFS, DSUM, DCOUNT??

See the strange occurrence of "Number 225", & "Text 225.00" being treated as the same thing for the criteria arguments in functions like COUNTIF, SUMIF, SUMIFS, DSUM, DCOUNT...

Strange COUNTIF Criteria Number and Text Number The Same?
Strange SUMIF Criteria Number and Text Number The Same?
StrangeSUMIFS Criteria Number and Text Number The Same?
Strange DSUM Criteria Number and Text Number The Same?
Strange DCOUNTCriteria Number and Text Number The Same?
Strange COUNTIFS Criteria Number and Text Number The Same?

[excelisfun]

Glad you like it! Thanks, ExcelStrategy for liking and commentsing on all the videos!!!

[excelisfun]

You are welcome! Yes, it is quite amazing all the variance...

[at-excel]

Hi and thanks for this very important Information. The variance of possibilities is unbelievible.

[excelisfun]

Yes, I do. FORMULATEXT is an Excel 2013 function. You don'y need to see the video, you just need to s=get 2013. Here is the video tile:

Excel 2013 Preview #4: FORMULATEXT Function: Show Formula From A Cell (Excel Magic Trick 952)
youtube. com/watch?v=yRdfa51IeEE

[excelisfun]

Google this: "macro 4 get.cell formula"

Look for: "Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL "

[AnandPenmatcha]

very good observation, and demostration

[lampros]

In order to count the number of 225 we can use the

[planiolro]

Great video! I tried to understand how can you show the content of the formulas next to the concerned cells so I downloaded the file but this formula xlfn.FORMULATEXT(D2) does not say to many things for me. Could you please elaborate? Or do u have a video on the topic?

[krn]

Great job Mike. Garbage in Garbage Out. Why didn't the original user just format as numbers. Lol.

[planiolro]

and for those having Excel 2007 what would be the solution?