How to highlight cells by values

How to highlight cells by values

Highlighting cells is a good way to visualize content to locate areas that needs attention. Excel’s Conditional Formatting feature is a great tool for this job. How to highlight cells by values article will show how you can create highlight cells based on...
How to count values by length

How to count values by length

This article shows how to count values by length based on their character count. This method can be helpful to check your data against invalid entries. It is also a good practice to use SUMPRODUCT and N functions together. Syntax =SUMPRODUCT(N(LEN(range)>character...
How to SUM 2d ranges with SUMPRODUCT

How to SUM 2d ranges with SUMPRODUCT

Summing values by a condition may sound easy. If not, please see Crunch Data Even Faster with the SUMIFS Function article as well. You can easily sum values by condition(s) with SUMIF and SUMIFS functions; with a limitation. The sum range and criteria ranges should...
How to SUM values across sheets

How to SUM values across sheets

To sum range of cells in the same worksheet is one of the basic concepts of Excel. What about summing values across sheets? In this article we will explain how to sum values across sheets. Syntax =SUM(first sheet : second sheet ! reference) Steps Start with =SUM( Type...