Functions and FormulasOn this pageFunctions and Formulas Pages Absolute reference Alternative of ifs and Averageif Concatenate Count Counta Countif Countunique Fill down copy a pattern in a row or column Filter Hlookup If Import XML Index + match Join Max Min Sumif Sumif Sumif vs sumifs Sumifs Text Join Vlookup Xlookup (office 365 only) Year month, day