With new support for named functions, LAMBDA and helper functions, spreadsheet calculations — especially with arrays — may be more efficient and elegant. Image: Andy Wolber/TechRepublic.

These functions allow for spreadsheets to surface data with a search, as seen in Collins’ demo. Beyond those powerful features, Google Sheets has also added a handful of other advanced features ...

New functions were also added to Google Sheets, some of which are exclusive to Google’s platform, and there are now more than 400 functions altogether that are supported in Google Sheets.

The SUMIF function can even sum numbers based on a date — such as values related to a specific date, or before or after a date. Suppose we want to total all the sales that happened on January 15.