=AVERAGE(number1,[number2],...)
number1 argument is used to number value/cell reference/range for which average is required
[number2] argument is used to another number value value/cell reference/range
… means, we can add multiple value/cell reference/range by separating them with comma ( , )
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
Watch: How to use WEEKDAY Function in Excel? What is WEEKDAY Function? In Excel, the WEEKDAY function returns the day of the week for a given date as a number Click here to Read Full…
This tutorial introduces XLOOKUP, a new function in Excel for both vertical and horizontal lookups. Tasks that used to feel super complicated, like left-side lookups, finding the last match, or using VLOOKUP with multiple criteria, are now much easier with XLOOKUP.
Before, you had to choose between VLOOKUP for vertical lookups, HLOOKUP for horizontal ones, or more complex options like INDEX MATCH or Power Query. But now, you don’t have to pick anymore. XLOOKUP can handle all those tasks in one simple function.
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…
In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.