Calculation & Formulas > Statistical Functions |
| How to count and sum cells based on background color in Excel? | SUBTOTALGET.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? | IFSUMPRODUCT |
| How to countif with multiple criteria in Excel? | COUNTIFSUMPRODUCT |
| How to count the number of days / workdays / weekends between two dates in Excel? | NETWORKDAYSSUMINTWEEKDAYSUMPRODUCT |
| How to count the number of words in a cell or a range cells in Excel? | IFLENTRIMSUBSTITUTESUM |
| How to find earliest and latest dates in a range in Excel? | MINSMALLMAXLARGE |
| How to count / sum only positive or negative numbers in Excel? | COUNTIFSUMIF |
| How to countif by date/month/year and date range in Excel? | SUMPRODUCTMONTHYEAR |
| 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? | SUMPRODUCTCOUNTIFINDIRECT |
| How to average a range of data ignoring zero in Excel? | AVERAGE |
| How to average absolute values in Excel? | AVERAGEABS |
| How to average based on day of week in Excel? | AVERAGEIFWEEKDAYSUMPRODCT |
| How to average cells based on multiple criteria in Excel? | AVERAGEIFAVERAGEIFS |
| How to average cells ignoring error values in Excel? | AVERAGEIFISERROR |
| How to average data based on weekday or weekend in Excel? | SUMWEEKDAY |
| How to average every 5 rows or columns in Excel? | AVERAGEOFFSETROW |
| 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? | IFCOUNTAVERAGEINDEXLARGEMINISNUMBERROWSUBTOTALOFFSET |
| How to average multiple vlookup findings in Excel? | AVERAGEIF |
| How to average non-adjacent/contiguous cells excluding zeroes in Excel? | AVERAGEIFMODCOLUMN |
| How to average only positive or negative numbers in Excel? | AVERAGEIF |
| How to average range with rounding in Excel? | ROUNDAVERAGEROUNDUPROUNDDOWN |
| How to average right result with missing values in Excel? | AGGERGATEAVERAGEIFISNUMBER |
| How to average timestamps of day in Excel? | INTAVERAGETEXT |
| How to average top or bottom 3 values in Excel? | AVERAGELARGEROWSMALLIF |
| How to average values if another column contains certain text in Excel? | IFERRORINDEXMATCHCOUNTIFAVERAGE |
| How to calculate average age by year/month/date in Excel? | SUMMONTHIFYEARAVERAGESUBTOTAL |
| How to calculate average between two dates in Excel? | AVERAGEIFSUMPRODUCT |
| 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? | AVERAGEINDIRECTIFINDEX |
| How to calculate average without max and min values in Excel? | SUMMINMAXCOUNTTRIMMEAN |
| How to calculate frequency distribution in Excel? | FREQUENCY |
| How to calculate median if multiple conditions in Excel? | MEDIANIF |
| How to calculate median in a range in Excel? | MEDIANIF |
| How to calculate median in an Excel pivot table? | MEDIANIF |
| 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.EQCOUNT |
| 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? | STDEVSQRTCOUNT |
| 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? | PERCENTILEQUARTILE |
| How to calculate weekly average in Excel? | WEEKNUMIFANDAVERAGEIFSAVERAGEIF |
| How to calculate weighted average in Excel? | SUMPRODUCTSUMSUMIF |
| How to count (identify) and change decimal place in Excel? | IFINTLENMIDFIND |
| How to count / calculate quarters between two dates in Excel? | FLOORYEARMONTH |
| How to count / sum cells based on filter with criteria in Excel? | SUBTOTALCOUNTVISIBLESUMVISIBLE |
| How to count / sum odd / even numbers or rows in Excel? | SUMPRODUCTMOD |
| How to count / sum only positive or negative numbers in Excel? | COUNTIFSUMIF |
| How to count a character in an Excel cell or a range? | LENSUBSTITUTESUMPRODUCT |
| 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? | AVERAGESUM |
| 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? | COUNTSUMPRODUCTNOTISNUMBERCOUNTA |
| How to count cells if one of multiple criteria met in Excel? | COUNTIFSUMSUMPRODUCT |
| 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? | SUMPRODUCTLENCOUNTCHAR |
| 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? | LENSUM |
| How to count comma separated values in a single cell in Excel? | LENTRIMSUBSTITUTE |
| How to count consecutive duplicates in Excel? | IF |
| How to count days between two dates including start date in Excel? | IFORINTNOTISBLANK |
| How to count duplicate values in a column in Excel? | COUNTIF |
| How to count duplicates between two columns in Excel? | SUMPRODUCTISNUMBERMATCH |
| How to count frequency of a text/number/character in Excel column? | SUMIFCOUNTIF |
| 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? | SUMPRODUCTLENSUBSTITUTE |
| 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? | COUNTIFCOUNTBLANK |
| How to count if cells are start with or end with specific text in Excel? | IFLEFTCOUNTIFRIGHT |
| 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? | SUBTOTALAGGERGATE |
| How to count ignoring zeros or blank cells in Excel? | COUNTIF |
| How to count max number of consecutive positive / negative numbers in Excel? | MAXFREQUENCYIFROW |
| How to count max or min occurrences in Excel? | COUNTIFMAX |
| How to count networkdays between two dates including Saturday in Excel? | SUMPRODUCTTEXTROWINDIRECT |
| 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? | COUNTIFCOUNTACOUNTIF |
| How to count number of cells with text or number in Excel? | COUNTACOUNT |
| How to count number of cells/rows until first blank in Excel? | MINIFROWMATCH |
| How to count number of certain/specific words in a cell or a range of cells in Excel? | LENSUBSTITUTE |
| How to count number of continuous blank cells in Excel? | IFISBLANKROWMAXNOT |
| 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? | COUNTIFREPTSUMPRODUCTLEN |
| How to count number of leap years between two dates in Excel? | DATEYEARANDMONTH |
| How to count number of lines (line breaks) in a cell in Excel? | LENSUBSTITUTECHAR |
| How to count number of occurrence in a column in Google sheet? | UNIQUECOUNTIFARRAYFORMULAQUERY |
| 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? | SUMPRODUCTIFAND |
| How to count occurrences of specific character in a cell in Excel? | SUMPRODUCTLENSUBSTITUTE |
| 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? | MATCHSUBTOTALOFFSETROWINDIRECTADDRESSCOLUMN |
| How to count same or duplicate values only once in a column? | SUMPRODUCTCOUNTIF |
| How to count specific characters (comma/semicolon/question marks) in cell/range in Excel? | LENSUBSTITUTE |
| How to count strings with leading zeros in Excel? | SUMPRODUCTSUM |
| How to count the cells above certain value or AVERAGE in Excel? | COUNTIFAVERAGE |
| 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? | LENSUBSTITUTECHAR |
| How to count the number of a word or character in an Excel column or cell? | COUNTIFLENSUBSTITUTE |
| How to count the number of cells with data in Excel? | COUNTA |
| How to count the number of characters excluding spaces in Excel cell? | LENSUBSTITUTE |
| How to count the number of characters, letters and numbers in cell? | LENSUBSTITUTESUM |
| How to count the number of commas/dashes separated values in a cell in Excel? | LENSUBSTITUTE |
| How to count the number of days except Sunday/weekends in Excel? | SUMIFWEEKDAYROWINDIRECTSUMPRODUCT |
| How to count the number of days or workdays in a month in Excel? | DAYDATEYEARMONTH |
| How to count the number of error cells / non error cells in Excel? | SUMISERRORCOUNTIFNOT |
| How to count the number of occurrences of a word in a column in Excel? | COUNTIFSUMIF |
| How to count the number of occurrences per year/quarter/month/week in Excel? | SUMPRODUCTMONTHYEAR |
| 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.CELLCOUNTIF |
| How to count the number of spaces before text string in Excel cell? | FINDLEFTTRIM |
| How to count the number of spaces of text string in Excel? | LENSUBSTITUTE |
| How to count the number of times a character / word appears in a cell? | LENSUBSTITUTE |
| How to count the number of times a word / number appears in a range? | SUMLEN |
| How to count the number of unique rows (combinations of multiple columns) in Excel? | SUMCOUNTIF |
| How to count the number of uppercase or lowercase letter in cell? | SUMPRODUCTLENSUBSTITUTECHARROWINDIRECT |
| How to count the number of weekends/weekdays between two dates in Excel? | INTWEEKDAY |
| How to count unique values based on another column in Excel? | SUMPRODUCTCOUNTIFS |
| How to count unique values based on multiple criteria in Excel? | SUMIFCOUNTIFCOUNTIFSDATE |
| How to count unique values between two dates in Excel? | SUMPRODUCTIFCOUNTIFS |
| How to count unique values excluding duplicates in Excel? | SUMIFFREQUENCYMATCHROW |
| How to count unique values in a filtered column in Excel? | SUMIFFREQUENCYSUBTOTALOFFSETROWMATCH |
| How to count unique values or numbers in a column in Excel? | SUMPRODUCTCOUNTIFSUMFREQUENCYIFMATCHLEN |
| How to count unique values with blanks in an Excel column? | SUMPRODUCTCOUNTIF |
| How to count unique values with multiple criteria in Excel? | COUNTIFSCOUNTIF |
| How to count unique/duplicate dates in an Excel column? | SUMPRODUCTCOUNTIF |
| How to count/sum the cells greater than but less than a number? | COUNTIFSUMIF |
| How to countif absolute values greater/less than given value in Excel? | SUMPRODUCTABSCOUNTIF |
| How to countif cell values with case sensitive in Excel? | SUMPRODUCTEXACTSUMIF |
| How to countif filtered data/list with criteria in Excel? | IFCOUNTIFSSUMPRODUCTSUBTOTALOFFSETMINROWISNUMBERSEARCH |
| How to countif partial string/substring match in Excel? | COUNTIFCOUNTIFS |
| How to countif something is in selected cells in Excel? | COUNTA |
| How to countif wildcards (asterisks or question marks) in Excel? | SUMLENSUBSTITUTE |
| How to determine frequency of a character/text/string in an Excel range? | SUMIFCOUNTIF |
| How to drop the lowest grade and get the average or total of values in Excel? | SUMSMALL |
| How to easily rank data by absolute value in Excel? | SUMPRODUCTABSRANK |
| How to easily rank list without ties in Excel? | RANKCOUNTIF |
| How to easily rank numbers skip blank cells in Excel? | IFISBLANKVALUEROWSMALLIFERRORMATCHRANK |
| How to find and get the largest value based on multiple criteria in Excel? | LARGEIFSUMPRODUCT |
| How to find and get the max or min value from a list of alphanumeric data in Excel? | LOOKUPCOUNTIF |
| How to find and get the nth largest value without duplicates in Excel? | MAXIF |
| How to find and return larger or smaller of two values in Excel? | MINMAX |
| How to find highest value in a row and return column header in Excel? | INDEXMATCHMAX |
| 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? | MAXMINIF |
| 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? | SMALLCOUNTIFMINIF |
| 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? | MINIFMAX |
| How to find the largest letter in a range in Excel? | LOOKUPCOUNTIF |
| How to find the lowest and highest 5 values in a list in Excel? | LARGEROWSSMALL |
| How to find the max or min value based on criteria in Excel? | MAXMINIF |
| How to find the max or min value for each day in an Excel range? | MAXMIN |
| How to find the maximum / minimum absolute values in Excel? | MAXABSMIN |
| How to find the maximum value in a dynamic Excel column? | MAXINDEXMATCHOFFSET |
| How to find the nth largest / smallest unique value in Excel? | LARGEIFISNUMBERROWMATCHSMALL |
| 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? | SUMPRODUCTSUM |
| How to limit formula result to maximum or minimum value in Excel? | MINSUMMAX |
| How to lookup latest or earliest date in Excel? | MINIFMAX |
| How to median values ignore zeros or errors in Excel? | MEDIANIFISNUMBER |
| 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? | COUNTIFSUMIF |
| How to quickly count the first instance only of values in Excel? | COUNTIFSUM |
| 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? | LARGESMALL |
| How to quickly find the largest value but smaller than X in Excel? | MAXIFSUMPRODUCT |
| How to quickly rank a league table in Excel? | COUNTIF |
| How to quickly rank a list by a specific value in Excel? | IFCOUNTIFS |
| How to quickly rank closet to zero or a specific value in Excel? | ABSRANKSUMPRODUCT |
| How to quickly rank data across multiple ranges and sheets in Excel? | IFSUMPRODUCTCOUNTIFINDIRECT |
| How to quickly rank non-continuous range in Excel? | RANKIFISNA |
| How to rank based on two columns in Excel? | RANKSUMPRODUCT |
| How to rank data by alphabetical order in Excel? | COUNTIF |
| How to rank data by occurrences in Excel? | COUNTIFRANK |
| 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? | RANKRANK.EQRANK.AVG |
| How to rank duplicate without skipping numbers in Excel? | RANKCOUNTIFSUMIF |
| How to rank if greater than 0 in Excel? | IFRANK |
| How to rank only visible cells in Excel? | SUMIFSUBTOTALOFFSETROW |
| How to rank positive and negative numbers separately in Excel? | IFMATCHSMALLROWINDIRECTCOUNTIFLARGE |
| How to rank range numbers uniquely without duplicates in Excel? | RANKCOUNTIF |
| How to rank values by group in Excel? | SUMPRODUCT |
| How to use countif to calculate the percentage in Excel? | COUNTIFCOUNTA |
Calculation & Formulas > Others |
| How to find nth occurrence (position) of a character in text string in Excel? | FINDSUBSTITUTECHAR |
| How to use IF function with AND, OR, and NOT in Excel? | IFANDOR |
| How to combine transpose function and If statement function in Excel? | IFCOUNTTRANSPOSE |
| How to create dynamic named range in Excel? | SUMOFFSETCOUNTA |
| How to define range based on another cell value in Excel? | AVERAGEINDIRECTCONCATENATESUMINDIRECT |
| How to determine if a number or value is in a range in Excel? | IFCOUNTIF |
| How to find and return the second to last value in a certain row or column in Excel? | INDEXLARGEROWIFOFFSETCOUNTA |
| How to find position of first/last number in a text string in Excel? | MINSEARCHMATCHABSMIDROWINDEXLENMAXISERRORVALUEINDIRECTISNUMBERFIND |
| 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? | SEARCHSUBSTITUTELENLOOKUPMIDROWINDIRECT |
| How to find the position of the first lowercase letter from text strings? | MATCHIFABSCODEMIDROWINDIRECTLEN |
| How to get a row or column letter of the current cell in Excel? | CHARROWLEFTADDRESSCOLUMN |
| How to get the address of active cell in Excel? | ADDRESSROWCOLUMN |
| How to get the cell value based on row and column numbers in Excel? | INDIRECTADDERESS |
| How to increase or increment cell reference by X in Excel? | OFFSETROW |
| 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? | ADDRESSROWCOLUMNROWSCOLUMNS |
| How to return filename without extension to cell? | MIDCELLSEARCHSUBSTITUTETRIMLEFTFINDREPT |
| How to return the row number of first or last non blank cell in worksheet? | ROWINDEXMATCHSUMPRODUCTMAX |
| How to use hlookup to sum a range of values in Excel? | SUMPRODUCTHLOOKUPSUMINDEX |
| How to use Replace function to replace and add string in Excel? | REPLACEDATEVALUEFIND |
| How to use SUBSTITUE function in Excel? | SUBSTITUTE |