Functions in Google Sheets

Functions in Google Sheets

Work with functions

Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.


AVERAGE

Statistical   Returns the numerical average value in a dataset, ignoring text.

AVERAGEIFS

Statistical  Returns the average of a range that depends upon multiple criteria.

CHOOSE

Lookup  Returns an element from a list of choices based on index.

COUNT

Statistical  Returns the count of the number of numeric values in a dataset.

COUNTIF

Statistical  Returns a conditional count across a range.

DATE

Date  Converts a provided year, month, and day into a date.

FIND

Text  Returns the position at which a string is first found within text.

GETPIVOTDATA

Text  Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.

IF

Logical  Returns one value if a logical expression is true and another if it is false.

INDEX

Lookup  Returns the content of a cell, specified by row and column offset.

INT

Math  Rounds a number down to the nearest integer that’s less than or equal to it.

LOOKUP

Lookup  Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.

MATCH

Lookup  Returns the relative position of an item in a range that matches a specified value.

MAX

Statistical  Returns the maximum value in a numeric dataset.

MIN

Statistical  Returns the minimum value in a numeric dataset.

NOW

Date  Returns the current date and time as a date value.

ROUND

Math  Rounds a number to a certain number of decimal places according to standard rules.

SUM

Math  Returns the sum of a series of numbers and/or cells.

SUMIF

Math  Returns a conditional sum across a range.

TODAY

Date  Returns the current date as a date value.

VLOOKUP

Lookup  Searches down the first column of a range for a key and returns the value of a specified cell in the row found.


    • Related Articles

    • PS Learning: Attach Google Docs, Sheets, and/or Slides to PSL content blocks

      Go to the add content block from any page and choose Google Drive. Then select the file or create the Google file right inside of PS Learning.

    • Create charts in Google Sheets

      Add charts In a spreadsheet, highlight the range of data you want to create a chart for. Click Insert > Chart. (Optional) In the editor, change the chart type and other aspects. (Optional) In the editor, to tailor axes, styles, titles, and more, ...

    • Embed Google Drive onto PS Learning Page

      Select Add Content Block and choose Google Drive to embed Documents, Sheets, Presentations, Drawings and other resources from your Google Drive. Collaboration tools can be enabled for Google Documents and Sheets.   Please note: This feature is only ...

    • Add Google Doc to File Block

      When creating a File Block through the Add Content Block menu, use the Choose from My Google Drive option to upload Documents, Sheets, Drawings and other resources from your Google Drive.    Please note: This feature is only available to School & ...

    • Format rows, columns in Google Sheets

      Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells. Delete or hide rows and columns—Right-click the row number or column letter and ...