Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Calculation & Formulas > User Defined Functions

Calculation & Formulas

Calculation & Formulas > Statistic

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

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 match to either X or Y in Excel?

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

How to count merged cells in selected range in Excel?

How to count number of cells with comments in Excel?

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

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

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

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

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

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

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

Calculation & Formulas > Math

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

How to quickly sum every other or nth row/column in Excel?

How to round range of numbers to even in Excel?

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

How to sum all digits in a number in Excel?

How to sum cells with text and numbers in Excel?

How to sum entire column except header/first row in Excel?

How to sum numbers in brackets only in Excel?

How to sum only filtered or visible cells in Excel?

How to sum or adding numbers in a single cell in Excel?

Calculation & Formulas > Look for a Value

How to apply negative vlookup to return the value in left of the key field in Excel?

How to lookup value return multiple corresponding values in Excel?

How to return multiple lookup values in one comma separated cell?

How to vlookup and concatenate multiple corresponding values in Excel?

How to vlookup and return background color along with the lookup value in Excel?

How to vlookup and return multiple values without duplicates in Excel?

How to vlookup to return multiple values in one cell in Excel?

How to VLOOKUP value case sensitive or insensitive in Excel?

Calculation & Formulas > Date or Time

How to calculate age before 1/1/1900 in Excel?

How to calculate Easter date in Excel?

How to check if a year is a leap year in Excel?

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

How to determine if a date falls between two dates or weekend in Excel?

How to get end of month date in Excel?

Calculation & Formulas > Others

How to apply same formula to multiple cells in Excel?

How to automatically increase letter by one to get the next letter in Excel?

How to calculate compound interest in Excel?

How to extract cell reference from formulas in Excel?

How to find nth occurrence (position) of a character in text string in Excel?

How to find the first, last or nth occurrence of a character in Excel?

How to find the position of the first lowercase letter from text strings?

How to get the cell value based on row and column numbers in Excel?

How to quickly get address of named range in Excel?