MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT returns every value tied for most frequent, where MODE.SNGL returns only the first.
Read article →MAXA Function in Excel: Largest Value, Logicals Included
MAXA Function in Excel: Largest Value, Logicals Included
MAXA is MAX that counts TRUE as 1 and text as 0.
Read article →AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA treats text as 0 and TRUE as 1. Use it when “absent” should drag the average down rather than be ignored.
Read article →AVERAGEIF Function in Excel: Average With One Condition
AVERAGEIF Function in Excel: Average With One Condition
AVERAGEIF averages values that meet one condition — often used to ignore zeros.
Read article →INFO Function in Excel: About Your Excel Environment
INFO Function in Excel: About Your Excel Environment
INFO returns details like the Excel version, operating system or current folder.
Read article →SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT multiplies arrays and adds the result — which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in every…
Read article →NA Function in Excel: Return #N/A on Purpose
NA Function in Excel: Return #N/A on Purpose
NA produces #N/A deliberately. Charts skip #N/A points instead of plotting them as zero.
Read article →FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY counts how many values fall into each bin — the data behind a histogram.
Read article →AVERAGEIFS Function in Excel: Average With Multiple Conditions
AVERAGEIFS Function in Excel: Average With Multiple Conditions
AVERAGEIFS averages values where all conditions are true.
Read article →ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE returns a number for each error (1 #NULL!, 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A) so you can…
Read article →TYPE Function in Excel: What Kind of Value Is This?
TYPE Function in Excel: What Kind of Value Is This?
TYPE returns 1 number, 2 text, 4 logical, 16 error or 64 array.
Read article →SHEETS Function in Excel: How Many Sheets?
SHEETS Function in Excel: How Many Sheets?
SHEETS counts sheets in a reference or the whole workbook — including hidden ones.
Read article →