Excel Function Playground
Type real formulas into a working sheet, then watch how Excel calculates them, one step at a time. Pick a function below for its own sample data, explanation, formula builder and downloadable example.
The playground runs in your browser. Nothing you type is sent anywhere.
Math and statistics
SUMAdds up numbers, cell references and ranges.AVERAGEReturns the arithmetic mean: the total of the numbers divided by how many there are.COUNTCounts how many cells contain numbers (including dates).COUNTACounts cells that are not empty: numbers, text, dates, logical values and errors.MINReturns the smallest number in a set of values.MAXReturns the largest number in a set of values.ROUNDRounds a number to a set number of digits, using normal rounding rules.ROUNDUPAlways rounds a number up, away from zero.ROUNDDOWNAlways rounds a number down, toward zero, by dropping digits.
Conditional sums and counts
SUMIFAdds the values that meet one condition.SUMIFSAdds the values that meet several conditions at once.COUNTIFCounts the cells that meet one condition.COUNTIFSCounts the rows that meet several conditions at once.AVERAGEIFAverages the values that meet one condition.AVERAGEIFSAverages the values that meet several conditions.
Logical
IFReturns one value if a condition is TRUE and another if it is FALSE.ANDReturns TRUE only when every condition is TRUE.ORReturns TRUE when at least one condition is TRUE.IFSChecks several conditions in order and returns the value for the first TRUE one.IFERRORReturns a value you choose when a formula results in an error.
Lookup and reference
VLOOKUPFinds a value in the first column of a table and returns a value from the same row.XLOOKUPFinds a value in one range and returns the matching item from another, in any direction.INDEXReturns the value at a given row and column position in a range.MATCHReturns the position of a value in a single row or column.
Text
CONCATJoins text from several cells or values into one piece of text.TEXTJOINJoins text with a separator you choose, optionally skipping empty cells.LEFTReturns the first characters of a text value.RIGHTReturns the last characters of a text value.MIDReturns characters from the middle of text, starting at a position you choose.TRIMRemoves extra spaces from text, leaving single spaces between words.TEXTTurns a number or date into text with the format you choose.
Date and time
TODAYReturns today's date, updated whenever the sheet recalculates.NOWReturns the current date and time.DATEDIFCounts the complete years, months or days between two dates.EOMONTHReturns the last day of the month, a number of months before or after a date.NETWORKDAYSCounts working days (Monday to Friday) between two dates, minus holidays.