Category: Formulas

Iferror Function

(adsbygoogle = window.adsbygoogle || []).push({}); What do you do when your formulas return error values for your calculations, your reports are filled with error values...

Formula Arrows

When there is too much stuff in your workbook and you start to lose which formula uses which cells, formula arrows will set you into...

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.