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. In August ...

Google Sheets is giving power users a boost this week, as the Excel alternative has just picked up XLOOKUP and several other long-missing features. Ben Collins, a Google Developer Expert working with ...

The Google Sheets spreadsheet tool has plenty to praise: It’s free, friendly for Android devices, and easily shareable for collaborative work. New users may be wondering just how similar it is to ...

Google Sheets is known to be a medium for housing your data. It’s what people use to track their personal finances, and it even comes in handy for several professional purposes. A rarely used feature ...

You can use the COUNTIF function in Google Sheets to find the number of items in a range that meet certain criteria. You can use text, numbers, and dates as criteria in the COUNTIF function. COUNTIF ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion. Here's everything you need to know to use the SUMIF ...