Category: Formulas

Subtotal Function

Subtotal function is a versatile function that can answer a lot of your needs all by itself. Besides it has some cool tricks in its...

Datedif Function

Datedif Function is used for calculating difference between two dates. I shows the results in days, months or years. Interesting thing is, Datedif Function is...

Global Sum

Here is a quick tip for summing values from different sheets. With this very powerful sum function, you can get totals of different sheets in...

Offset Function

When you want to select a cell (or range of cells), that is 2 rows down and 3 columns to the right from Cell B12,...

Sumproduct Function

Sum product function lets you calculate sum of values with corresponding arrays. For example, if you have sales quantites and unit prices for a series...

Unit Conversion In Excel

Excel has a built-in unit converter. Not surprising isn’t it? Unit conversion is excel is done with CONVERT() Function. Here is how it works…