IT's RAINING XL FUNCTIONS!!! 🌧
XLOOKUP - lookup a value in a list and return matching result
SUMIFS - add values that meet one or more criteria
FILTER - filter matching values in a table
COUNTIFS - count values that meet conditions
UNIQUE - remove duplicate duplicate values in a list
SORT - arrange values in sort order
INDEX - return a value at a given position in a table
TEXTJOIN - combines text values with a delimiter
EDATE - calculates future or past dates by adding months
IFERROR - shows a different value when your formula e$%ors