by Ilker | Mar 28, 2019 | Excel Formulas

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...
by Ilker | Jun 13, 2018 | Excel Tips & Tricks

The SUMIFS function can sum values based on multiple conditions. However, these conditions are all linked with AND operator. As a result, all conditions should be fulfilled to return a value. This article shows How you can sum values with multiple OR operators using...
by Ilker | May 30, 2018 | Excel Tips & Tricks

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...
by Ilker | Apr 2, 2018 | Excel Tips & Tricks

A final exam is worth more in terms of graduation score and the term weighed average becomes relevant. In such cases, SUMPRODUCT formula can help calculate the weighed totals of a data set. In our example, test scores of 3 candidates are being compared. Although...
by Adam | Mar 21, 2018 | Blog

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...
by Ilker | Oct 7, 2019 | Excel Formulas

The Excel MOD function is a Math and Trigonometry formula which calculates and returns the remainder after the number is divided by the divisor. This is called a modulo operation. This operation sees frequent use in math problems and building a model, and you can use...
by Ilker | Jan 8, 2019 | Excel Formulas

The N function is an information function that returns a value converted to a number. In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax N(value)ArgumentsvalueThe...
by Ilker | Jan 8, 2019 | Excel Tips & Tricks

The double minus, also known as double unary, is an operation to convert Boolean values into ones and zeroes. Simply; TRUE to one (1) and FALSE to zero (0). A unary operation is an operation with only one operand, which is in contrast to binary operations that use two...
by Ilker | Aug 30, 2018 | Excel Tips & Tricks

Although the AVERAGEIF and AVERAGEIFS function can sum values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to create a year-by-year average calculator with help of the...