Posts Tagged 'Google Sheets functions'

If VLOOKUP in Google Sheets is not working

How to do a Vlookup without errors in Google Sheets? Take a closer look at the most common mistakes made when working with the VLOOKUP function. Continue reading

SUMIFS in Google Sheets to sum cells with multiple criteria (AND / OR logic)

Google Spreadsheets provide two functions to conditionally sum cells, SUMIF and SUMIFS. Regular visitors of our blog are already familiar with the SUMIF function that we covered last week, and today we are going to have a closer look at its plural version. Continue reading

SUMIF in Google Sheets with formula examples

Google Sheets has two functions to add up numbers based on conditions: SUMIF and SUMIFS. The former evaluates just one condition while the latter can test multiple conditions at a time. In this tutorial, we will focus solely on the SUMIF function. Continue reading

Columns in Google Sheets - split text to columns and convert columns to rows

I'd like to share with you a few more pieces of advice about columns in Google Sheets. If you ever needed to split the content from one column into separate ones or turn the table around so that columns become rows, this is your lucky day. Today I'm going to reveal a few quick tips on how to do that. Continue reading

How to calculate currency exchange rates in Google Sheets with GoogleFinance

Find out how to use the GOOGLEFINANCE function to get the current currency exchange rates or the rates over some period of time in Google Sheets. You'll get to know what arguments the function has and how to manage them easily. Continue reading

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

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

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

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

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

Google Sheets IF function - usage and formula examples

Get to know Google Sheets IF function better with this tutorial: when is it used, how does it work and how it contributes to a much simpler data processing. Formula examples are included! Continue reading

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite 2018.4 Summer Offer