Calculation & Formulas > Statistical Functions
|
How to count and sum cells based on background color in Excel? |
SUBTOTAL GET.CELL |
How to calculate average/compound annual growth rate in Excel? |
XIRR |
How to count / calculate weeks / months / years between two dates in Excel? |
DATEDIF |
How to count duplicate values in a column in Excel? |
COUNTIF |
How to count if cell contains text or part of text in Excel? |
COUNTIF |
How to count unique values in pivot table? |
IF SUMPRODUCT |
How to countif with multiple criteria in Excel? |
COUNTIF SUMPRODUCT |
How to count the number of days / workdays / weekends between two dates in Excel? |
NETWORKDAYS SUM INT WEEKDAY SUMPRODUCT |
How to count the number of words in a cell or a range cells in Excel? |
IF LEN TRIM SUBSTITUTE SUM |
How to find earliest and latest dates in a range in Excel? |
MIN SMALL MAX LARGE |
How to count / sum only positive or negative numbers in Excel? |
COUNTIF SUMIF |
How to countif by date/month/year and date range in Excel? |
SUMPRODUCT MONTH YEAR |
How to count number of “Yes” or “No” answer in Excel? |
COUNTIF |
How to count number of cells between two values or dates in Excel? |
COUNTIFS |
How to countif a specific value across multiple worksheets? |
SUMPRODUCT COUNTIF INDIRECT |
How to average a range of data ignoring zero in Excel? |
AVERAGE |
How to average absolute values in Excel? |
AVERAGE ABS |
How to average based on day of week in Excel? |
AVERAGE IF WEEKDAY SUMPRODCT |
How to average cells based on multiple criteria in Excel? |
AVERAGEIF AVERAGEIFS |
How to average cells ignoring error values in Excel? |
AVERAGE IF ISERROR |
How to average data based on weekday or weekend in Excel? |
SUM WEEKDAY |
How to average every 5 rows or columns in Excel? |
AVERAGE OFFSET ROW |
How to average filtered cells/list in Excel? |
SUBTOTAL |
How to average for cells with values only (exclude 0 or blank cells) in Excel? |
AVERAGEIF |
How to average last 5 values of a column as new numbers entering? |
IF COUNT AVERAGE INDEX LARGE MIN ISNUMBER ROW SUBTOTAL OFFSET |
How to average multiple vlookup findings in Excel? |
AVERAGE IF |
How to average non-adjacent/contiguous cells excluding zeroes in Excel? |
AVERAGE IF MOD COLUMN |
How to average only positive or negative numbers in Excel? |
AVERAGE IF |
How to average range with rounding in Excel? |
ROUND AVERAGE ROUNDUP ROUNDDOWN |
How to average right result with missing values in Excel? |
AGGERGATE AVERAGE IF ISNUMBER |
How to average timestamps of day in Excel? |
INT AVERAGE TEXT |
How to average top or bottom 3 values in Excel? |
AVERAGE LARGE ROW SMALL IF |
How to average values if another column contains certain text in Excel? |
IFERROR INDEX MATCH COUNTIF AVERAGE |
How to calculate average age by year/month/date in Excel? |
SUM MONTH IF YEAR AVERAGE SUBTOTAL |
How to calculate average between two dates in Excel? |
AVERAGE IF SUMPRODUCT |
How to calculate average cells from different sheets in Excel? |
AVERAGE |
How to calculate average in a column based on criteria in another column in Excel? |
AVERAGEIF |
How to calculate average numbers greater than 0 in Excel? |
AVERAGEIF |
How to calculate average of dynamic range in Excel? |
AVERAGE INDIRECT IF INDEX |
How to calculate average without max and min values in Excel? |
SUM MIN MAX COUNT TRIMMEAN |
How to calculate frequency distribution in Excel? |
FREQUENCY |
How to calculate median if multiple conditions in Excel? |
MEDIAN IF |
How to calculate median in a range in Excel? |
MEDIAN IF |
How to calculate median in an Excel pivot table? |
MEDIAN IF |
How to calculate midpoint between two dates in Excel? |
SUM |
How to calculate moving/rolling average in Excel? |
AVERAGE |
How to calculate rank percentile of a list in Excel? |
RANK.EQ COUNT |
How to calculate running total / average in Excel? |
SUM |
How to calculate standard deviation in Excel? |
STDEV |
How to calculate standard error of the mean in Excel? |
STDEV SQRT COUNT |
How to calculate the median in visible cells only in Excel? |
AGGERGATE |
How to calculate the percentile and quartile of a set of numbers in Excel? |
PERCENTILE QUARTILE |
How to calculate weekly average in Excel? |
WEEKNUM IF AND AVERAGEIFS AVERAGEIF |
How to calculate weighted average in Excel? |
SUMPRODUCT SUM SUMIF |
How to count (identify) and change decimal place in Excel? |
IF INT LEN MID FIND |
How to count / calculate quarters between two dates in Excel? |
FLOOR YEAR MONTH |
How to count / sum cells based on filter with criteria in Excel? |
SUBTOTAL COUNTVISIBLE SUMVISIBLE |
How to count / sum odd / even numbers or rows in Excel? |
SUMPRODUCT MOD |
How to count / sum only positive or negative numbers in Excel? |
COUNTIF SUMIF |
How to count a character in an Excel cell or a range? |
LEN SUBSTITUTE SUMPRODUCT |
How to count all cells except a specific value in Excel? |
COUNTIF |
How to count all cells with value/data in a range in Excel? |
COUNTA |
How to count and remove duplicates from a list in Excel? |
COUNTIF |
How to count blank cells as zero when using average in Excel? |
AVERAGE SUM |
How to count blank cells or nonblank cells in a range in Excel? |
COUNTIF |
How to count blank or non-blank cells in filtered range in Excel? |
SUBTOTAL |
How to count cells between two times in Excel? |
SUMPRODUCT |
How to count cells containing numbers or not in Excel? |
COUNT SUMPRODUCT NOT ISNUMBER COUNTA |
How to count cells if one of multiple criteria met in Excel? |
COUNTIF SUM SUMPRODUCT |
How to count cells match to either X or Y in Excel? |
COUNTIF |
How to count cells that equal to a certain value in Excel? |
COUNTIF |
How to count cells with length greater than a specific number in Excel? |
SUMPRODUCT LEN COUNTCHAR |
How to count cells with question marks in Excel? |
COUNTIF |
How to count cells with specific text in selection in Excel? |
COUNTIF |
How to count cells with zeros but not blanks in Excel? |
COUNTIF |
How to count cells/records by group in Excel? |
COUNTIF |
How to count characters in cell/range/worksheet in Excel? |
LEN SUM |
How to count comma separated values in a single cell in Excel? |
LEN TRIM SUBSTITUTE |
How to count consecutive duplicates in Excel? |
IF |
How to count days between two dates including start date in Excel? |
IF OR INT NOT ISBLANK |
How to count duplicate values in a column in Excel? |
COUNTIF |
How to count duplicates between two columns in Excel? |
SUMPRODUCT ISNUMBER MATCH |
How to count frequency of a text/number/character in Excel column? |
SUM IF COUNTIF |
How to count how many cells contain certain text or value in Excel? |
COUNTIF |
How to count how often a word or a value occurs in Excel? |
SUMPRODUCT LEN SUBSTITUTE |
How to count if cell does not contain text in Excel? |
COUNTIF |
How to count if cells are nonblank and not equal to specific word in Excel? |
COUNTIF COUNTBLANK |
How to count if cells are start with or end with specific text in Excel? |
IF LEFT COUNTIF RIGHT |
How to count if cells contain any date/data in Excel? |
COUNTA |
How to count if value falls within a given range in Excel? |
FREQUENCY |
How to count ignore hidden cells/rows/columns in Excel? |
SUBTOTAL AGGERGATE |
How to count ignoring zeros or blank cells in Excel? |
COUNT IF |
How to count max number of consecutive positive / negative numbers in Excel? |
MAX FREQUENCY IF ROW |
How to count max or min occurrences in Excel? |
COUNTIF MAX |
How to count networkdays between two dates including Saturday in Excel? |
SUMPRODUCT TEXT ROW INDIRECT |
How to count number of cells greater or less than 0 (zero) in Excel? |
COUNTIF |
How to count number of cells with nonzero values in Excel? |
COUNTIF COUNTA COUNTIF |
How to count number of cells with text or number in Excel? |
COUNTA COUNT |
How to count number of cells/rows until first blank in Excel? |
MIN IF ROW MATCH |
How to count number of certain/specific words in a cell or a range of cells in Excel? |
LEN SUBSTITUTE |
How to count number of continuous blank cells in Excel? |
IF ISBLANK ROW MAX NOT |
How to count number of half hour intervals in Excel? |
FLOOR |
How to count number of instances if string length is greater than X in Excel? |
COUNTIF REPT SUMPRODUCT LEN |
How to count number of leap years between two dates in Excel? |
DATE YEAR AND MONTH |
How to count number of lines (line breaks) in a cell in Excel? |
LEN SUBSTITUTE CHAR |
How to count number of occurrence in a column in Google sheet? |
UNIQUE COUNTIF ARRAYFORMULA QUERY |
How to count number of occurrence in a datetime range in Excel? |
SUMPRODUCT |
How to count number of peaks in a column of data in Excel? |
SUMPRODUCT IF AND |
How to count occurrences of specific character in a cell in Excel? |
SUMPRODUCT LEN SUBSTITUTE |
How to count records between two dates with matching criteria in Excel? |
SUMPRODUCT |
How to count rows until a certain sum value is reached in Excel? |
MATCH SUBTOTAL OFFSET ROW INDIRECT ADDRESS COLUMN |
How to count same or duplicate values only once in a column? |
SUMPRODUCT COUNTIF |
How to count specific characters (comma/semicolon/question marks) in cell/range in Excel? |
LEN SUBSTITUTE |
How to count strings with leading zeros in Excel? |
SUMPRODUCT SUM |
How to count the cells above certain value or AVERAGE in Excel? |
COUNTIF AVERAGE |
How to count the days excluding Sundays between two dates in Excel? |
WEEKDAY |
How to count the difference between letters in Excel? |
CODE |
How to count the line breaks in cell in Excel? |
LEN SUBSTITUTE CHAR |
How to count the number of a word or character in an Excel column or cell? |
COUNTIF LEN SUBSTITUTE |
How to count the number of cells with data in Excel? |
COUNTA |
How to count the number of characters excluding spaces in Excel cell? |
LEN SUBSTITUTE |
How to count the number of characters, letters and numbers in cell? |
LEN SUBSTITUTE SUM |
How to count the number of commas/dashes separated values in a cell in Excel? |
LEN SUBSTITUTE |
How to count the number of days except Sunday/weekends in Excel? |
SUM IF WEEKDAY ROW INDIRECT SUMPRODUCT |
How to count the number of days or workdays in a month in Excel? |
DAY DATE YEAR MONTH |
How to count the number of error cells / non error cells in Excel? |
SUM ISERROR COUNTIF NOT |
How to count the number of occurrences of a word in a column in Excel? |
COUNTIF SUM IF |
How to count the number of occurrences per year/quarter/month/week in Excel? |
SUMPRODUCT MONTH YEAR |
How to count the number of populated cells in a range in Excel? |
COUNTA |
How to count the number of shaded cells in Excel? |
GET.CELL COUNTIF |
How to count the number of spaces before text string in Excel cell? |
FIND LEFT TRIM |
How to count the number of spaces of text string in Excel? |
LEN SUBSTITUTE |
How to count the number of times a character / word appears in a cell? |
LEN SUBSTITUTE |
How to count the number of times a word / number appears in a range? |
SUM LEN |
How to count the number of unique rows (combinations of multiple columns) in Excel? |
SUM COUNTIF |
How to count the number of uppercase or lowercase letter in cell? |
SUMPRODUCT LEN SUBSTITUTE CHAR ROW INDIRECT |
How to count the number of weekends/weekdays between two dates in Excel? |
INT WEEKDAY |
How to count unique values based on another column in Excel? |
SUMPRODUCT COUNTIFS |
How to count unique values based on multiple criteria in Excel? |
SUM IF COUNTIF COUNTIFS DATE |
How to count unique values between two dates in Excel? |
SUMPRODUCT IF COUNTIFS |
How to count unique values excluding duplicates in Excel? |
SUM IF FREQUENCY MATCH ROW |
How to count unique values in a filtered column in Excel? |
SUM IF FREQUENCY SUBTOTAL OFFSET ROW MATCH |
How to count unique values or numbers in a column in Excel? |
SUMPRODUCT COUNTIF SUM FREQUENCY IF MATCH LEN |
How to count unique values with blanks in an Excel column? |
SUMPRODUCT COUNTIF |
How to count unique values with multiple criteria in Excel? |
COUNTIFS COUNTIF |
How to count unique/duplicate dates in an Excel column? |
SUMPRODUCT COUNTIF |
How to count/sum the cells greater than but less than a number? |
COUNTIF SUMIF |
How to countif absolute values greater/less than given value in Excel? |
SUMPRODUCT ABS COUNTIF |
How to countif cell values with case sensitive in Excel? |
SUMPRODUCT EXACT SUM IF |
How to countif filtered data/list with criteria in Excel? |
IF COUNTIFS SUMPRODUCT SUBTOTAL OFFSET MIN ROW ISNUMBER SEARCH |
How to countif partial string/substring match in Excel? |
COUNTIF COUNTIFS |
How to countif something is in selected cells in Excel? |
COUNTA |
How to countif wildcards (asterisks or question marks) in Excel? |
SUM LEN SUBSTITUTE |
How to determine frequency of a character/text/string in an Excel range? |
SUM IF COUNTIF |
How to drop the lowest grade and get the average or total of values in Excel? |
SUM SMALL |
How to easily rank data by absolute value in Excel? |
SUMPRODUCT ABS RANK |
How to easily rank list without ties in Excel? |
RANK COUNTIF |
How to easily rank numbers skip blank cells in Excel? |
IF ISBLANK VALUE ROW SMALL IFERROR MATCH RANK |
How to find and get the largest value based on multiple criteria in Excel? |
LARGE IF SUMPRODUCT |
How to find and get the max or min value from a list of alphanumeric data in Excel? |
LOOKUP COUNTIF |
How to find and get the nth largest value without duplicates in Excel? |
MAX IF |
How to find and return larger or smaller of two values in Excel? |
MIN MAX |
How to find highest value in a row and return column header in Excel? |
INDEX MATCH MAX |
How to find largest negative value (less than 0) in Excel? |
MAX |
How to find max or min value in a certain date range (between two dates) in Excel? |
MAX MIN IF |
How to find max or min value in a group in Excel? |
IF |
How to find minimum value in a range excluding zero value in Excel? |
SMALL COUNTIF MIN IF |
How to find smallest positive value (greater than 0) in Excel? |
MIN |
How to find the earliest or latest date base on criteria in Excel? |
MIN IF MAX |
How to find the largest letter in a range in Excel? |
LOOKUP COUNTIF |
How to find the lowest and highest 5 values in a list in Excel? |
LARGE ROWS SMALL |
How to find the max or min value based on criteria in Excel? |
MAX MIN IF |
How to find the max or min value for each day in an Excel range? |
MAX MIN |
How to find the maximum / minimum absolute values in Excel? |
MAX ABS MIN |
How to find the maximum value in a dynamic Excel column? |
MAX INDEX MATCH OFFSET |
How to find the nth largest / smallest unique value in Excel? |
LARGE IF ISNUMBER ROW MATCH SMALL |
How to find/select minimum data/value in a range in Excel? |
MIN |
How to get max/min of visible cells only in Excel? |
SUBTOTAL |
How to ignore blanks when calculate the weighted average in Excel? |
SUMPRODUCT SUM |
How to limit formula result to maximum or minimum value in Excel? |
MIN SUM MAX |
How to lookup latest or earliest date in Excel? |
MIN IF MAX |
How to median values ignore zeros or errors in Excel? |
MEDIAN IF ISNUMBER |
How to quickly color ranking in Excel? |
RANK |
How to quickly count appearance in every 15 minutes in Excel? |
INT |
How to quickly count if cells are equal to x or y in Excel? |
COUNTIF SUM IF |
How to quickly count the first instance only of values in Excel? |
COUNTIF SUM |
How to quickly count the number of cells until value changes in Excel? |
COUNTIF |
How to quickly find or return the second highest or smallest value in Excel? |
LARGE SMALL |
How to quickly find the largest value but smaller than X in Excel? |
MAX IF SUMPRODUCT |
How to quickly rank a league table in Excel? |
COUNTIF |
How to quickly rank a list by a specific value in Excel? |
IF COUNTIFS |
How to quickly rank closet to zero or a specific value in Excel? |
ABS RANK SUMPRODUCT |
How to quickly rank data across multiple ranges and sheets in Excel? |
IF SUMPRODUCT COUNTIF INDIRECT |
How to quickly rank non-continuous range in Excel? |
RANK IF ISNA |
How to rank based on two columns in Excel? |
RANK SUMPRODUCT |
How to rank data by alphabetical order in Excel? |
COUNTIF |
How to rank data by occurrences in Excel? |
COUNTIF RANK |
How to rank data in reverse order in Excel? |
RANK |
How to rank data with multiple references in Excel? |
SUMPRODUCT |
How to rank data without sorting in Excel? |
RANK |
How to rank duplicate values in Excel? |
RANK RANK.EQ RANK.AVG |
How to rank duplicate without skipping numbers in Excel? |
RANK COUNTIF SUM IF |
How to rank if greater than 0 in Excel? |
IF RANK |
How to rank only visible cells in Excel? |
SUM IF SUBTOTAL OFFSET ROW |
How to rank positive and negative numbers separately in Excel? |
IF MATCH SMALL ROW INDIRECT COUNTIF LARGE |
How to rank range numbers uniquely without duplicates in Excel? |
RANK COUNTIF |
How to rank values by group in Excel? |
SUMPRODUCT |
How to use countif to calculate the percentage in Excel? |
COUNTIF COUNTA |
Calculation & Formulas > Others
|
How to find nth occurrence (position) of a character in text string in Excel? |
FIND SUBSTITUTE CHAR |
How to use IF function with AND, OR, and NOT in Excel? |
IF AND OR |
How to combine transpose function and If statement function in Excel? |
IF COUNT TRANSPOSE |
How to create dynamic named range in Excel? |
SUM OFFSET COUNTA |
How to define range based on another cell value in Excel? |
AVERAGE INDIRECT CONCATENATE SUM INDIRECT |
How to determine if a number or value is in a range in Excel? |
IF COUNTIF |
How to find and return the second to last value in a certain row or column in Excel? |
INDEX LARGE ROW IF OFFSET COUNTA |
How to find position of first/last number in a text string in Excel? |
MIN SEARCH MATCH ABS MID ROW INDEX LEN MAX ISERROR VALUE INDIRECT ISNUMBER FIND |
How to find position of nth space in Excel string? |
FIND |
How to find the first, last or nth occurrence of a character in Excel? |
SEARCH SUBSTITUTE LEN LOOKUP MID ROW INDIRECT |
How to find the position of the first lowercase letter from text strings? |
MATCH IF ABS CODE MID ROW INDIRECT LEN |
How to get a row or column letter of the current cell in Excel? |
CHAR ROW LEFT ADDRESS COLUMN |
How to get the address of active cell in Excel? |
ADDRESS ROW COLUMN |
How to get the cell value based on row and column numbers in Excel? |
INDIRECT ADDERESS |
How to increase or increment cell reference by X in Excel? |
OFFSET ROW |
How to increment worksheet reference automatically in Excel? |
INDIRECT |
How to prevent cell reference in a formula from incrementing /changing in Excel? |
SUM |
How to quickly get address of named range in Excel? |
ADDRESS ROW COLUMN ROWS COLUMNS |
How to return filename without extension to cell? |
MID CELL SEARCH SUBSTITUTE TRIM LEFT FIND REPT |
How to return the row number of first or last non blank cell in worksheet? |
ROW INDEX MATCH SUMPRODUCT MAX |
How to use hlookup to sum a range of values in Excel? |
SUMPRODUCT HLOOKUP SUM INDEX |
How to use Replace function to replace and add string in Excel? |
REPLACE DATEVALUE FIND |
How to use SUBSTITUE function in Excel? |
SUBSTITUTE |