# Posts tagged "Google Sheets functions", page 2

## 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

## How to split cells in Google Sheets

If you ever needed to split text from one cell into separate columns, this is your lucky day. Today I'm going to share 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