# Spreadsheet functions ## Definition(s) ### Context [[Spreadsheet]] >[! Definition] >A preset command that automatically performs a specified process or task using the data in a spreadsheet. ## Functions #### A - [[AVERAGE|=AVERAGE()]] - [[AVERAGEIF|=AVERAGEIF()]] #### C - [[CONCAT|=CONCAT()]] - [[CONCATENATE|=CONCATENATE()]] - [[CONVERT|=CONVERT()]] - [[COUNTIF|=COUNTIF()]] - [[COUNTIFS|=COUNTIFS()]] #### D - [[DATEDIF|=DATEDIF()]] #### F - [[FIND|=FIND()]] #### I - [[IFERROR|=IFERROR()]] - [[IMPORTRANGE|=IMPORTRANGE()]] #### L - [[LEFT|=LEFT()]] - [[LEN|=LEN()]] #### M - [[MAX]] - [[MAXIFS|=MAXIFS()]] - [[MID|=MID()]] - [[MIN]] - [[MINIFS|=MINIFS()]] - [[MATCH|=MATCH()]] #### Q - [[Query|=QUERRY()]] #### R - [[RIGHT|=RIGHT()]] #### S - [[SORT|=SORT()]] - [[Split|=SPLIT()]] - [[SUM|=SUM()]] - [[SUMIF|=SUMIF()]] - [[SUMIFS|=SUMIFS()]] - preferred because it can take more than a single conditional evaluations point. - [[SUMPRODUCT|=SUMPRODUCT()]] #### T - [[TEXT]] - [[TRIM|=TRIM()]] #### V - [[VLOOKUP|=VLOOKUP()]] ## Related ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)