DAVERAGE Function in Excel: Average With a Criteria Table
DatabaseLevel: ExpertAvailable in: Excel 2007+DAVERAGE averages a column for rows that meet the criteria range.Syntax=DAVERAGE(database, field.
Read article →COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF counts cells that meet one condition. It is also the simplest duplicate checker.
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 →EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND pads an array to a given number of rows and columns — handy before VSTACK when pieces have different widths.
Read article →INDIRECT Function in Excel: Build a Reference From Text
INDIRECT Function in Excel: Build a Reference From Text
INDIRECT turns text such as "Mar!B5" into a real reference — the key to dependent dropdowns and summary sheets that switch between monthly tabs.
Read article →LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE returns the k-th largest value; SMALL returns the k-th smallest. Together they build top-N lists in any version.
Read article →DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT counts numeric cells in a column for matching rows. Use DCOUNTA to count any non-blank cell instead.
Read article →ISNA Function in Excel: Is It “Not Found”?
ISNA Function in Excel: Is It “Not Found”?
ISNA returns TRUE only for #N/A — the “not found” result — so you can react to missing lookups specifically.
Read article →TAKE Function in Excel: First or Last N Rows of a Range
TAKE Function in Excel: First or Last N Rows of a Range
TAKE returns the first (or last, with a negative number) rows or columns of an array — perfect for top-N reports.
Read article →PERCENTOF Function in Excel: Share of the Total
PERCENTOF Function in Excel: Share of the Total
PERCENTOF returns a subset’s share of a total — mostly used inside GROUPBY and PIVOTBY to show % of total.
Read article →TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE returns everything before a delimiter; TEXTAFTER everything after. They replace most LEFT/FIND and MID/FIND combinations.
Read article →FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML extracts values from XML with an XPath. Its famous side use: splitting text in versions without TEXTSPLIT.
Read article →