# Category: Google Sheets Functions Tips & Tutorials

### How to Sum Cell Values Between Two Dates in Google Sheets

The SUMIFS function in Google Sheets is quite helpful in a variety of situations, including those where you want to

Watch our step-by-step video tutorial: There are certain statistical metrics that are often used to analyze and get a basic

### How to Use REGEXEXTRACT Google Sheets Function

REGEXEXTRACTÂ  Google Sheets function is part of the suite of REGEX functions available to many users. The function is extremely

### How to Use REGEXREPLACE Function in Google Sheets

REGEXREPLACE is a handy function offered by Google Sheets that lets you quickly replace parts of strings in your sheets.

### How to Use the INDEX function in Google Sheets (Examples)

The INDEX function is perhaps one of the most under-used functions in Google Sheets. However, if you know the right

### How to Convert Time to Decimal in Google Sheets

If your dataset contains date and time values, there might be situations where you need to convert them to decimal

### Formula Parse Error in Google Sheets (& How to Fix it)

Formulas in Google Sheets were meant to make things easier for us. However, every Formula user, irrespective of whether itâ€™s

### How to Use SWITCH function in Google Sheets?

The SWITCH function in Google Sheets is a helpful tool for changing how a cell behaves based on the value

### How to Round Numbers in Google Sheets? (ROUNDUP/ROUNDDOWN)

Google Sheets makes it easy to round numbers. It features several functions that can accommodate a wide-range of rounding. Whether

### How To Calculate Weighted Average In Google Sheets (Weighted Average Formula)

You can calculate weighted averages in Google Sheets by using a built-in formula: AVERAGE.WEIGHTED. Weighted averages are useful for calculating

### How to VLOOKUP Multiple Columns in Google Sheets?

VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value