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 remove blanks from a list

How to remove blanks from a list

We often find data in a raw, unorganized form that contain empty cells. In this article we’re going to show you how to remove blanks from a list and create a new table using only formulas. Syntax =IFERROR(INDEX(list range,SMALL(IF(ISTEXT(list range),ROW(rows...
A New Dimension Building Excel Models: Array Formulas

A New Dimension Building Excel Models: Array Formulas

Excel’s array formulas are indeed a fascinating subject. Although they can be very useful by making it possible to solve some complex calculations, and replace hundreds of formulas in certain situations, most Excel users have probably never used these formulas before...