This is a catalog of working formulas for calculations, searching, and working with data. For example, the formula for the sum for the current month updates automatically.

Copy the text from the examples, substitute your own ranges, and save hours. Everything is tested in the latest versions of Excel and Google Sheets.

The XLOOKUP function is especially useful, but if it doesn't work, check three specific XLOOKUP settings that are most often the cause of failure.

🔗 Source: excel.rf