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 spreadsheetlite. 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.