Excel Indirect Function – How to Use

Excel Indirect Function is one of the most useful functions in Microsoft Excel. Indirect function takes a cell reference in the form of a string, then it evaluates the reference and shows its content. This gives you a better way to deal with variable cell references.Excel Indirect Function Syntax:The syntax of indirect function is quite … [Read more...]

Excel SUMPRODUCT Function – How To Use

On hearing the name of Excel SUMPRODUCT Function for the first time, it looks like some useless formula that can do some predefined sum and product operations. But actually it’s far from that definition. In fact it is a very useful function if you need to analyse the data of two or multiple arrays in excel.How Excel Defines SUMPRODUCT … [Read more...]