## Sum if cells are not blank or sum if cells are blank

Sumif function of excel is one of most useful function if used properly. Let's use sumif function to add cells…

## Sum if cell contain number

Letâ€™s say we want to sum if celll contain number i.e. adding those cells which are having sale amount of…

## How does a Sumif function work in Excel?

Sum function of excel add the cells which are selected by cell reference, but what if I want to add…

## Advance lookup with Index and Match function – 9 Practical Examples for Beginners and Advance Users

Having difficult time understanding Index and Match functions? Here is the complete step by step guide with 9 practical example…

## How to Use Absolute, Relative and Mixed Cell Reference in Excel?

Knowing relative, absolute and mixed cell references of excel can save lot of time. Here is the detail explanation.