One handy feature in Grow is the ability to use spreadsheet functions to manipulate your data. While the functions in Grow have some similarities to Excel functions, there are some differences. If Excel or Google Docs is a full powered spreadsheet, Grow is more a spreadsheet-lite. This article will explain what functions Grow has and how to use them.

Here is a list of all of the spreadsheet functions in Grow:

• Sum
• Multiply
• Average
• Count
• Min
• Max
• Stdev
• Countif
• Countifs
• Sumif
• Sumifs
• Arithmetic operators: + - / * ()
• If
• Importseries
• Transpose
• Unique
• Last
• First
• Left(string, [numberOfCharacters])
• Right(string, [numberOfCharacters])
• Round(number, [places])
• Mid(string, startPosition, length)

The following section will explain how to use each function or operator in Grow and how they compare to Excel. Given that this list is extensive, if you are looking for a specific function or operator, we recommend using Ctrl+F to search for it.

Sum

• How to use it: Returns the sum of a series of numbers and/or cells.
• Grow Example: =SUM(report1!A2:A100, 101)
• Excel Comparison: =SUM function adds a range of numbers/cells.

Multiply

• What it does: Returns the product of a series of numbers and/or cells.
• Grow Example: =MULTIPLY(report1!B1:A100)
• Excel Comparison: =PRODUCT function multiplies a range of numbers/cells.

Average

• What it does: Returns the average of a series of numbers and/or cells.
• Grow Example: =AVERAGE(report1!A)
• Excel Comparison: =AVERAGE function returns the average of a range of numbers

Count

• What it does: Returns the amount size (count) of a series
• Grow Example: =COUNT(report1!A)
• Excel Comparison: =COUNT function returns how many numbers are in a range of numbers/cells

Min

• What it does: Returns the minimum value of a series of numbers and or/cells
• Grow Example: =MIN(report1!A)
• Excel Comparison: =MIN function returns the minimum value in a range of numbers/cells

Max

• What it does: Returns the maximum value of a series of numbers and or/cells
• Grow Example: =MAX(report1!A)
• Excel Comparison: =MAX function returns the maximum value in a range of numbers/cells

Stdev

• What it does: Returns the standard deviation of a series of numbers and or/cells
• Grow Example: =STDEV(report1!A)
• Excel Comparison: =STDEV.P function calculates the standard deviation based on the entire population (of data)

Countif

• What it does: Returns the count of a range based on a condition you specify.
• Grow Example: =COUNTIF(report1!A, ">10")
• Excel Comparison: =COUNTIF function counts the number of cells within a range that meet the given criteria

Countifs

• What it does: Returns the count of a range with multiple criteria
• Grow Example: =COUNTIFS(report2!A, "Esther", report2!C, "5")
• Excel Comparison: =COUNTIFS function counts the number of cells within a range that meet multiple criteria

Sumif

• What it does: Returns the sum of a range based on a condition that you specify.
• Grow Example: =SUMIF(report1!A, ">10")
• Excel Comparison: =SUMIF function adds the cells specified by a given criteria

Sumifs

• What it does: Returns the sum of a range depending on multiple criteria.
• Grow Example: =SUMIFS(report2!B, report2!A, report2!A2, report2!C, "5")
• Excel Comparison: =SUMIFS functions adds the cells in a range that meet multiple criteria.

+, -, /, *, ( )

• What it does: Each operator can be used with any of the functions listed above. They will return a single numerical value based on what the operator does.
• Grow Example: =MAX(report1!A) + SUM(report1!B) / 5 - 1.5
• Excel Comparison: `+` (plus sign) operator performs addition. `-` (minus sign) performs subtraction or negation. `*` (asterisk) performs multiplication). `/` (forward slash) performs division.

If

• What it does: Returns one value if a logical expression is TRUE and another if it is FALSE
• Grow Example: =IF(report1!A1, "<5", "Great", "Bad")
• In this example, if a cell is less than 5 (true), then it enters the word “Great.” If not (false), then it enters the word “Bad.”
• Excel Comparison: =IF function does something if a cell is true and something else if it is false.

Importseries

• What it does: Copies the results of a reference or expression into a row or column. IMPORTSERIES can be used in conjunction with UNIQUE, DATEFORMAT, LEFT, RIGHT, MID, SUBSTRING, TIMEMANIPULATE
• Grow Example: =IMPORTSERIES(UNIQUE(DATEFORMAT(report1!E, "MMMM")))
• Excel Comparison: N/A

One note with IMPORTSERIES: be sure that you are not importing multiples series into the same column. The first series will pull in the column for that series and overwrite anything that is below it.

Transpose

• What it does: Copies the results of a reference or expression into a row or column. If the source was a column, the destination will be a row, and vice versa. TRANSPOSE can be used in conjunction with UNIQUE, DATEFORMAT, LEFT, RIGHT, MID, SUBSTRING, TIMEMANIPULATE
• Grow Example: =TRANSPOSE(UNIQUE(report1!E))
• Excel Comparison: =TRANSPOSE function transposes the selected cells into a row or column.

Unique

• What it does: Returns a unique value in the selected range, discarding duplicates. Values are returned in the order in which they are encountered in the range. UNIQUE is most often used inside of IMPORTSERIES or TRANSPOSED, and then applied to DATEFORMAT, LEFT, RIGHT, MID, SUBSTRING, TIMEMANIPULATE
• Grow Example: =IMPORTSERIES(UNIQUE(report1!E))
• Excel Comparison: N/A

Last

• What it does: Returns the last value in the selected range.
• Grow Example: =LAST(REPORT1!E,-1)
• You can also check out this help article for more info on how to use the Last function.
• Excel Comparison: N/A

First

• What it does: Returns the first value in the selected range.
• Grow Example: =FIRST(report1!E)
• Excel Comparison: N/A

Left(string, [numberOfCharacters])

• What it does: Returns a substring from the beginning of a specified string.
• Grow Example: =LEFT(report2!A2, 3)
• Excel Comparison: =LEFT function returns the first character(s) in a text string, based on number of characters you specify.

Right(string, [numberOfCharacters])

• What it does: Returns a substring from the end of a specified string.
• Grow Example: =RIGHT(report2!A2)
• Excel Comparison: Returns the rightmost characters in a text string, based on the number of characters you specify.

Round(number, [places])

• What it does: Rounds the number to the specified number of places.
• Grow Example: =ROUND(report2!A2, 1)
• Excel Comparison: =ROUND function rounds a number to a specified number of digits.

Mid(string, startPosition, length)

• What it does: Returns a segment of a string.
• Grow Example: =MID(report2!A2, 3, 2)
• Excel Comparison: =MID function returns a specific number of characters from a text string starting where you specify.

Questions about spreadsheet functions? Email us at support@grow.com or chat in on the site.