Reporting Add-on: Helpful Formulas & Features

Use the list of Google Sheet formulas below as a starting point to building your own reporting tabs.  Be sure to check out the full list of Google Sheet functions HERE or do a Google Search for countless videos that show how to use Google Sheets.

Function: Array

Google Functions:

• ARRAY – https://support.google.com/docs/answer/6208276
• ARRAYFORMULA – https://support.google.com/docs/answer/3093275
• AVERAGE – https://support.google.com/docs/answer/3093615
• AVERAGEIFS – https://support.google.com/docs/answer/3256534
• COUNT – https://support.google.com/docs/answer/3093620
• COUNTIFS – https://support.google.com/docs/answer/3256550
• FILTER – https://support.google.com/docs/answer/3093197
• LOOKUP – https://support.google.com/docs/answer/3256570
• VLOOKUP – https://support.google.com/docs/answer/3093318
• HLOOKUP – https://support.google.com/docs/answer/3093375
• MAX – https://support.google.com/docs/answer/3094013
• MIN – https://support.google.com/docs/answer/3094017
• QUERY – https://support.google.com/docs/answer/3093343
• SORT – https://support.google.com/docs/answer/3093150
• SUM – https://support.google.com/docs/answer/3093669
• SUMIFS – https://support.google.com/docs/answer/3238496
• UNIQUE – https://support.google.com/docs/answer/3093198

Google Features:

• Data Validation – https://cloud.google.com/blog/products/g-suite/pro-tip-how-create-dropdown-list-google-sheets-and-pointers-conditional-formatting
• Conditional Formatting – https://support.google.com/docs/answer/78413