Professor Excel
subtotal, excel, guide, tutorial

SUBTOTAL in Excel: Everything You Should Know

SUBTOTAL is one of those formulas in Excel, which is very powerful but not well known. The reason is, that you can achieve all its operations by other formulas as well. But in many cases, SUBTOTAL would be the better choice. Read here how to use it and why SUBTOTAL is very useful.


sumifs, excel, tutorial

SUMIFS in Excel: Everything You Need to Know (+Download)

The SUMIFS formula adds up all numbers, when one or more than one criterion is fulfilled. SUMIFS only exists since Excel 2007 and is especially useful, as it can regard several search criteria.

sum, sum up, excel, add, addition

Sum in Excel: 8 Ways Of Adding Up Values

One of the basic applications in Excel is summing up values. The most popular ways of adding up numbers are just using the ‘+’ sign or the formula SUM. But there are many other methods. Do you know about these 6 other ways to sum up values in Excel? In this article we’ll take a look at 8 methods for summing up values in Excel and compare them.