Log in
x
or
x
x
Register
x

or

Excel Tips: Calculation & Formulas > Statistic Functions

AVERAGE Function

Average by date

How to average based on day of week in Excel?

How to average data based on weekday or weekend in Excel?

How to average per day/month/quarter/hour with pivot table in Excel?

How to average timestamps of day in Excel?

How to calculate average age by year/month/date in Excel?

How to calculate average between two dates in Excel?

How to calculate midpoint between two dates in Excel?

How to calculate weekly average in Excel?

How to sum or average values if dates in adjacent cells equal to specified month in Excel?

Average ignoring cells

How to average a range of data ignoring zero in Excel?

How to average cells ignoring error values in Excel?

How to average filtered cells/list in Excel?

How to average for cells with values only (exclude 0 or blank cells) in Excel?

How to average last 5 values of a column as new numbers entering?

How to average non-adjacent/contiguous cells excluding zeroes in Excel?

How to average only positive or negative numbers in Excel?

How to average right result with missing values in Excel?

How to average top or bottom 3 values in Excel?

How to calculate average without max and min values in Excel?

How to drop the lowest grade and get the average or total of values in Excel?

How to quickly average visible/filtered cells only in Excel?

How to sum / average ignore negative values in Excel?

How to sum or average unique values only in Excel?

Average with criteria

How to average cells based on multiple criteria in Excel?

How to average every 5 rows or columns in Excel?

How to average multiple vlookup findings in Excel?

How to average values based on cell color in Excel?

How to average values if another column contains certain text in Excel?

How to calculate average in a column based on criteria in another column in Excel?

How to calculate average numbers greater than 0 in Excel?

Weight average

How to calculate weighted average in an Excel Pivot Table?

How to calculate weighted average in Excel?

How to ignore blanks when calculate the weighted average in Excel?

Others

How to average absolute values in Excel?

How to average range with rounding in Excel?

How to calculate average cells from different sheets in Excel?

How to calculate average of dynamic range in Excel?

How to calculate average rate of change in Excel?

How to calculate average speed from distance and time in Excel?

How to calculate average/compound annual growth rate in Excel?

How to calculate moving/rolling average in Excel?

How to calculate running total /average in Excel?

How to count blank cells as zero when using AVERAGE in Excel?

COUNT Function

Count characters or words

How to count a character in an Excel cell or a range?

How to count characters in cell/range/worksheet in Excel?

How to count comma separated values in a single cell in Excel?

How to count frequency of a text/number/character in Excel column?

How to count how often a word or a value occurs in Excel?

How to count max or min occurrences in Excel?

How to count number of “Yes” or “No” answer in Excel?

How to count number of certain/specific words in a cell or a range of cells in Excel?

How to count number of lines (line breaks) in a cell in Excel?

How to count number of occurrence in a column in Google sheet?

How to count occurrences of specific character in a cell in Excel?

How to count specific characters (comma/semicolon/question marks) in cell/range in Excel?

How to count the frequency of text values in a column?

How to count the line breaks in cell in Excel?

How to count the number of a word or character in an Excel column or cell?

How to count the number of characters excluding spaces in Excel cell?

How to count the number of characters, letters and numbers in cell?

How to count the number of commas/dashes separated values in a cell in Excel?

How to count the number of occurrences of a word in a column in Excel?

How to count the number of occurrences per year/quarter/month/week in Excel?

How to count the number of spaces before text string in Excel cell?

How to count the number of spaces of text string in Excel?

How to count the number of times a character / word appears in a cell?

How to count the number of times a word / number appears in a range?

How to count the number of uppercase or lowercase letter in cell?

How to count the number of words in a cell or a range cells in Excel?

How to countif wildcards (asterisks or question marks) in Excel?

How to determine frequency of a character/text/string in an Excel range?

Count days between two dates

How to check if a date is public holiday and count days except holidays in Excel?

How to count / calculate quarters between two dates in Excel?

How to count / calculate weeks / months / years between two dates in Excel?

How to count days between two dates including start date in Excel?

How to count number of leap years between two dates in Excel?

How to count the days excluding Sundays between two dates in Excel?

How to count the number of days / workdays / weekends between two dates in Excel?

How to count the number of days except Sunday/weekends in Excel?

How to count the number of days or workdays in a month in Excel?

How to count the number of weekends/weekdays between two dates in Excel?

Count duplicate or unique cells

How to compare two columns and count differences in Excel?

How to count and remove duplicates from a list in Excel?

How to count consecutive duplicates in Excel?

How to count duplicate values in a column in Excel?

How to count duplicates between two columns in Excel?

How to count same or duplicate values only once in a column?

How to count the number of unique rows (combinations of multiple columns) in Excel?

How to count unique values based on another column in Excel?

How to count unique values based on multiple criteria in Excel?

How to count unique values between two dates in Excel?

How to count unique values excluding duplicates in Excel?

How to count unique values in a filtered column in Excel?

How to count unique values in pivot table?

How to count unique values or numbers in a column in Excel?

How to count unique values with blanks in an Excel column?

How to count unique values with multiple criteria in Excel?

How to count unique/duplicate dates in an Excel column?

How to count unique/duplicate dates in an Excel column?

How to find and count duplicate cells/values in a single row in Excel?

How to quickly count the first instance only of values in Excel?

Count ignoring cells

How to count / sum cells based on filter with criteria in Excel?

How to count / sum odd / even numbers or rows in Excel?

How to count / sum only positive or negative numbers in Excel?

How to count all cells with value/data in a range in Excel?

How to count blank cells or nonblank cells in a range in Excel?

How to count blank or non-blank cells in filtered range in Excel?

How to count blank or non-blank cells in filtered range in Excel?

How to count if cells contain any date/data in Excel?

How to count ignore hidden cells/rows/columns in Excel?

How to count ignoring zeros or blank cells in Excel?

How to count number of cells with nonzero values in Excel?

How to count number of continuous blank cells in Excel?

How to count the number of cells with data in Excel?

How to count the number of populated cells in a range in Excel?

How to Countif filtered data/list with criteria in Excel?

How to quickly count visible or filtered cells only in Excel?

Count sheets or workbooks

How to count the number of sheets of a workbook?

How to count the number of visible sheets in a workbook?

How to count worksheets with specific name in Excel?

How to quickly count the number of all opened workbooks?

How to quickly count the number of hidden worksheets in Excel?

Count specific cells

How to count / sum cells based on the font colors in Excel?

How to count / sum strikethrough cells in Excel?

How to count and sum cells based on background color in Excel?

How to count cells by specific formatting such as Bold, Italic in Excel?

How to count cells containing numbers or not in Excel?

How to count cells with specific text and fill/font color in Excel?

How to count number of cells with comments in Excel?

How to count or sum cells based on cell color in Google sheet?

How to count the number of error cells / non error cells in Excel?

How to count the number of shaded cells in Excel?

How to count/sum cells by colors with conditional formatting in Excel?

How to sum / count bold numbers in a range of cells in Excel?

Count with criteria

How to count all cells except a specific value in Excel?

How to count cells beginning with specific letter in Excel?

How to count cells between two times in Excel?

How to count cells if one of multiple criteria met in Excel?

How to count cells match to either X or Y in Excel?

How to count cells that equal to a certain value in Excel?

How to count cells with length greater than a specific number in Excel?

How to count cells with question marks in Excel?

How to count cells with specific text in selection in Excel?

How to count cells with zeros but not blanks in Excel?

How to count cells/records by group in Excel?

How to count data by group in Excel?

How to count how many cells contain certain text or value in Excel?

How to count if cell contains text or part of text in Excel?

How to count if cell does not contain text in Excel?

How to count if cells are nonblank and not equal to specific word in Excel?

How to count if cells are start with or end with specific text in Excel?

How to count if value falls within a given range in Excel?

How to count networkdays between two dates including Saturday in Excel?

How to count number of cells between two values or dates in Excel?

How to count number of cells greater or less than 0 (zero) in Excel?

How to count number of cells with text or number in Excel?

How to count number of cells/rows until first blank in Excel?

How to count number of instances if string length is greater than X in Excel?

How to count number of occurrence in a datetime range in Excel?

How to count records between two dates with matching criteria in Excel?

How to count rows until a certain sum value is reached in Excel?

How to count strings with leading zeros in Excel?

How to count the cells above certain value or average in Excel?

How to count/sum the cells greater than but less than a number?

How to countif a specific value across multiple worksheets?

How to countif absolute values greater/less than given value in Excel?

How to Countif by date/month/year and date range in Excel?

How to countif partial string/substring match in Excel?

How to countif with multiple criteria in Excel?

How to quickly count appearance in every 15 minutes in Excel?

How to quickly count if cells are equal to x or y in Excel?

How to quickly count the number of cells until value changes in Excel?

Others

How to count (identify) and change decimal place in Excel?

How to count files in a certain folder/directory in Excel?

How to count max number of consecutive positive / negative numbers in Excel?

How to count merged cells in selected range in Excel?

How to count number of half hour intervals in Excel?

How to count number of peaks in a column of data in Excel?

How to count number of times a cell is changed in Excel?

How to count or calculate hours worked between times in Excel?

How to count page breaks of active sheet in Excel?

How to count the difference between letters in Excel?

How to count the number of printed pages in a sheet?

How to count the page numbers of Pdf files in Excel?

How to count total clicks in a specified cell in Excel?

How to count total rows in a table in Excel?

How to countif cell values with case sensitive in Excel?

How to countif something is in selected cells in Excel?

How to sum / count checked checkboxes in Excel?

How to sum or count first n values in an Excel column or row?

MAX or MIN Functions

How to find and get the largest value based on multiple criteria in Excel?

How to find and get the max or min value from a list of alphanumeric data in Excel?

How to find and get the nth largest value without duplicates in Excel?

How to find and return larger or smaller of two values in Excel?

How to find earliest and latest dates in a range in Excel?

How to find highest value in a row and return column header in Excel?

How to find largest negative value (less than 0) in Excel?

How to find max or min value based on unique values in Excel?

How to find max or min value in a certain date range (between two dates) in Excel?

How to find max or min value in a group in Excel?

How to find minimum value in a range excluding zero value in Excel?

How to find smallest positive value (greater than 0) in Excel?

How to find the earliest or latest date base on criteria in Excel?

How to find the highest value and return adjacent cell value in Excel?

How to find the largest letter in a range in Excel?

How to find the lowest and highest 5 values in a list in Excel?

How to find the max or min value based on criteria in Excel?

How to find the max or min value for each day in an Excel range?

How to find the maximum / minimum absolute values in Excel?

How to find the maximum value in a dynamic Excel column?

How to find the nth largest / smallest unique value in Excel?

How to find/select minimum data/value in a range in Excel?

How to get max/min of visible cells only in Excel?

How to limit formula result to maximum or minimum value in Excel?

How to lookup latest or earliest date in Excel?

How to quickly find or return the second highest or smallest value in Excel?

How to quickly find the largest value but smaller than X in Excel?

How to sum largest or smallest 3 values in a list of Excel?

MEDIAN Function

How to calculate median if multiple conditions in Excel?

How to calculate median in a range in Excel?

How to calculate median in an Excel pivot table?

How to calculate the median in visible cells only in Excel?

How to median values ignore zeros or errors in Excel?

PERCENTILE or QUARTILE Functions

How to calculate rank percentile of a list in Excel?

How to calculate the percentile and quartile of a set of numbers in Excel?

How to quickly calculate percentile or quartile ignore zeros in Excel?

RANK Function

How to calculate rank percentile of a list in Excel?

How to easily rank data by absolute value in Excel?

How to easily rank list without ties in Excel?

How to easily rank numbers skip blank cells in Excel?

How to quickly color ranking in Excel?

How to quickly rank a league table in Excel?

How to quickly rank a list by a specific value in Excel?

How to quickly rank closet to zero or a specific value in Excel?

How to quickly rank data across multiple ranges and sheets in Excel?

How to quickly rank non-continuous range in Excel?

How to quickly rank values ignore errors in Excel?

How to rank based on two columns in Excel?

How to rank data by alphabetical order in Excel?

How to rank data by occurrences in Excel?

How to rank data ignore zero values in Excel?

How to rank data in reverse order in Excel?

How to rank data with multiple references in Excel?

How to rank data without sorting in Excel?

How to rank duplicate values in Excel?

How to rank duplicate without skipping numbers in Excel?

How to rank if greater than 0 in Excel?

How to rank only visible cells in Excel?

How to rank positive and negative numbers separately in Excel?

How to rank range numbers uniquely without duplicates in Excel?

How to rank values by group in Excel?

How to rank values excluding subtotal in Excel?

Others

How to calculate frequency distribution in Excel?

How to calculate standard deviation in Excel?

How to calculate standard error of the mean in Excel?

How to use countif to calculate the percentage in Excel?