Look Who it Was Random video

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

3,937 views · Published 23 August 2013 · 5:38 · Indexed 1 November 2026

Channel: excelisfun · 2013 · Education

Watch on YouTube

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1043-1046.xlsm

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
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?

More from this channel