How to calculate running totals in Excel Tables

How to calculate running totals in Excel Tables

by | Jul 11, 2018

This article shows how to calculate running totals in Excel Tables by using structured references. If your data is not in a Table, please continue with this article: How to calculate running count Syntax =SUM(INDEX([column of values],1):[@ column of values]) Steps...
How to create a Quarter formula in Excel

How to create a Quarter formula in Excel

by | Jul 10, 2018

There is no specific Quarter formula in Excel. But an Excel quarter formula can be constructed by combining ROUNDUP and MONTH functions with custom number formatting. Syntax =ROUNDUP( MONTH( date value ) /3, 0 ) Steps Start with =ROUNDUP( function Continue with MONTH(...
How to generate Excel month names

How to generate Excel month names

by | Jul 10, 2018

This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting. Syntax =DATE( YEAR( previous date ), MONTH( previous date )+1, 1)...
How to create a dynamic drop down list in Excel

How to create a dynamic drop down list in Excel

by | Jul 6, 2018

Creating a dynamic Excel drop down list is very useful If you have a list that is updated frequently. This article shows you how to create a dynamic drop down list with the help of OFFSET and COUNTA functions. Syntax =OFFSET(title of list, 1, 0, COUNTA(column that...
How to get Excel cell address of a lookup result

How to get Excel cell address of a lookup result

by | Jul 4, 2018

This article shows you how to get Excel cell address of a lookup result by using the CELL and INDEX functions. Syntax =CELL( “address”, INDEX( data, MATCH( lookup value for row, lookup range for row, 0 ), column index ) ) Steps Start with the =CELL(...
How to change number format in Excel chart

How to change number format in Excel chart

by | Jul 3, 2018

Excel charts are one of the most used and easy to understand data visualization tools. Excel provides many chart types as well as numerous personalization options. One of the cool features is the ability to change number format in Excel chart. Steps Double-click on...
Case Sensitive Count

Case Sensitive Count

by | Jul 2, 2018

Case sensitive count can not be handled easily using standard count formulas like COUNTIF or COUNTIFS. In this article, we’ll shot you how you can count case sensitive data by using a combination of SUMPRODUCT and EXACT functions. Syntax...
How to calculate average of values with OR operator

How to calculate average of values with OR operator

by | Jun 13, 2018

The AVERAGEIFS function can calculate the average of values with multiple conditions. However, these conditions are linked with AND operator. But if you want to handle AVERAGE OR combination, AVERAGEIFS function will not work. This article shows how to calculate...