Function: SUMPRODUCT

Function: SUMPRODUCT

The SUMPRODUCT Excel formula is a Math & Trig function that multiplies the values in arrays, and returns the sum of products. Although this sounds like something you could do using a combination of the SUM and the PRODUCT formulas, there is more to it! Thanks to...
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...
Using SUMPRODUCT to Do Your Taxes

Using SUMPRODUCT to Do Your Taxes

It’s that time of the year! Of course there are all kinds of tools out there you can use to calculate and submit your taxes for the last year, but it’s always a good idea to double check everything and if you prefer to do everything by hand, you might find this guide...
How to count if not equal to x or y in Excel

How to count if not equal to x or y in Excel

The COUNTIFS function can count the values in multiple ranges with multiple criteria. The function counts each given range-criteria pair and combines the result with AND logical operator. Unfortunately, there is no quick and easy way to use an OR logic with the...
How to make Excel calculate faster

How to make Excel calculate faster

Excel is a fairly an efficient software given that it can perform complex calculations. However, depending on your system, it can also get pretty slow when running complicated calculations. How formulas are used, and size of the workbook are typically the culprit if...