Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function

Download File: http://ift.tt/2v5xN3c
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
In the English United States Regional Settings, SUMIFS seems to be recognizing Text and Number Dates as equivalent Criteria. But when we change the Reginal Settings, SUMIFS correctly interprets Text Dates and Number Dates as different. This Tip comes from Awesome Online Teammate, Bill Szysz!!!

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.