Category: Formulas

Extract Text From String

If you need to extract text from string in Excel with a known character, there is an easy way of doing this with just one...

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...