Posts Tagged 'Google sheets functions'

Nov
16

Google Sheets COUNT and COUNTA functions with formula examples

Learn how to count the number of cells with various data types. What data is processed by COUNT? How does COUNT differ from COUNTA? What can I count with these functions? Find out the answers to these and some other questions in today's article. Continue reading

Oct
19

Calculating time in Google Sheets: subtract, sum and extract date and time units

It's time to talk about the ways of calculating time in Google Sheets. We'll discuss the ways of finding time difference in detail, see how to sum dates and time together, and learn to display only date or time units and set them apart completely. Continue reading

Sep
7

How to work with conditional formatting in Google Sheets

Highlighting certain data with color is a great way to draw attention to the records. Wouldn’t it be great if such format change happened automatically for specific cells? This is where conditional formatting comes in handy. Google Sheets can do this work for us, all we need is to explain what we want to get. Continue reading

Jul
5

Google Sheets VLOOKUP with examples

A widespread opinion is that VLOOKUP is one of the most difficult and obscure functions. But that's not true! In fact, it's easy to do VLOOKUP in Google Sheets, and in a moment you will make sure of it. Continue reading

Jun
29

Google Spreadsheet COUNTIF function with formula examples

We continue exploring the possibilities of Google Spreadsheets with COUNTIF function. Learn why you may need it and how it can be applied to your daily work with the tables. Continue reading

Excel add-ins and Outlook tools - Ablebits.com