Excel Magic Trick 1457 Part 2

Regional Settings & Text or Number Date / Times in SUMIFS Function

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1455-1460” Excel-Magic-Trick-1455-1460.zip – Downloaded 32 times – 5 MB







Be the first to comment

Leave a Reply