Category: Formulas

Sumifs Function

Are you tired of creating helper columns to be able to fetch data with sumif function? If you need to sum of a list of...

Vlookup Function

Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...

Named Ranges

Did you know that you can give a name to your ranges or cells in excel? And using these named ranges, while you can work...

Sumif Function

When you need to get sum of a list of vaules depending on one condition, sumif function is here to help.

Choose Function

When you need to pick a value from a list of values depending on an index number, choose function is the one you need.

Nested functions

While excel has a lot of built-in formulas ready for your use, sometimes they may not fully fit the task at hand. In this kind...