Excel functions, with examples
71 functions explained in plain language. Every example here has been checked in real Excel, and you can try each one in your browser.
71 functions
- MathSUMAdds up numbers.
- MathSUMIFAdds only the rows that meet one condition.
- MathSUMIFSAdds only the rows that meet several conditions.
- MathSUMPRODUCTMultiplies matching items in lists, then adds the results.
- MathROUNDRounds a number to a set number of digits.
- MathROUNDUPRounds a number up, away from zero.
- MathROUNDDOWNRounds a number down, toward zero.
- MathMODReturns the remainder after dividing.
- MathABSRemoves the minus sign from a number.
- StatisticsAVERAGEFinds the mean of a list of numbers.
- StatisticsAVERAGEIFAverages only the rows that meet a condition.
- StatisticsMEDIANFinds the middle value of a list.
- StatisticsMODE.SNGLFinds the most common value.
- StatisticsMINFinds the lowest value.
- StatisticsMAXFinds the highest value.
- StatisticsMAXIFSFinds the highest value among rows that meet a condition.
- StatisticsMINIFSFinds the lowest value among rows that meet a condition.
- StatisticsLARGEFinds the nth largest value.
- StatisticsSMALLFinds the nth smallest value.
- StatisticsRANK.EQGives a number’s place in a list.
- StatisticsCOUNTCounts cells that contain numbers.
- StatisticsCOUNTACounts cells that aren’t empty.
- StatisticsCOUNTIFCounts the rows that meet one condition.
- StatisticsCOUNTIFSCounts the rows that meet several conditions.
- LogicIFReturns one result if a test is true, and another if it isn’t.
- LogicIFSChecks tests in order, and returns the result for the first true one.
- LogicSWITCHMatches a value against a list, and returns the paired result.
- LogicANDReturns TRUE only if every test passes.
- LogicORReturns TRUE if at least one test passes.
- LogicNOTFlips TRUE to FALSE, and FALSE to TRUE.
- LogicIFERRORShows a replacement when a formula returns an error.
- LogicIFNAShows a replacement only for #N/A errors.
- LogicISBLANKReturns TRUE if a cell is empty.
- LogicISNUMBERReturns TRUE if a value is a number.
- LookupXLOOKUPFinds a value in one list, and returns the matching value from another.
- LookupVLOOKUPSearches the first column of a table, and returns from a column you choose by number.
- LookupHLOOKUPSearches the top row of a table, and returns from a row you choose by number.
- LookupINDEXReturns the value at a given position in a range.
- LookupMATCHReturns the position of a value in a list.
- LookupOFFSETReturns a value a set number of rows and columns from a starting cell.
- LookupCHOOSEPicks from a list of options by number.
- TextLEFTTakes characters from the start of text.
- TextRIGHTTakes characters from the end of text.
- TextMIDTakes characters from the middle of text.
- TextLENCounts the characters in text.
- TextFINDGives the position of text within text, matching capitals exactly.
- TextSEARCHGives the position of text within text, ignoring capitals.
- TextTRIMRemoves extra spaces from text.
- TextUPPERChanges text to capitals.
- TextLOWERChanges text to lowercase.
- TextPROPERCapitalizes the first letter of each word.
- TextSUBSTITUTEReplaces specific text with other text.
- TextTEXTTurns a number into text in a format you choose.
- TextCONCATJoins pieces of text together.
- TextTEXTJOINJoins a list with a separator between each item.
- TextTEXTBEFOREReturns the text before a marker.
- TextTEXTAFTERReturns the text after a marker.
- DatesDATEBuilds a date from a year, month and day.
- DatesYEARReturns the year of a date.
- DatesMONTHReturns the month of a date, as a number.
- DatesDAYReturns the day of the month from a date.
- DatesEDATEMoves a date forward or back by whole months.
- DatesEOMONTHReturns the last day of a month.
- DatesDAYSCounts the days between two dates.
- DatesDATEDIFCounts complete years, months or days between two dates.
- DatesNETWORKDAYSCounts working days between two dates.
- DatesWORKDAYFinds the date a number of working days away.
- Dynamic arraysUNIQUEReturns a list with the duplicates removed.
- Dynamic arraysSORTReturns a sorted copy of a list.
- Dynamic arraysFILTERReturns only the rows that pass a test.
- Dynamic arraysSEQUENCEGenerates a list of numbers.