Excel formulas

Using Array Formulas in Excel

An Array formula works with an array. You may see array formulas referred to as “CSE formulas,” because you press […]

SUMPRODUCT function in Excel returns the sum of the products of the corresponding ranges or arrays. Let’s check the syntax

The process of looking up specific values in a data set is the most common task in Excel. If your

SUMIF: SUMIF function in Microsoft Excel, adds the cells specified by a criteria. Syntax for this excel function =Sumif(range, criteria,

COUNTIF: The COUNTIF function in Microsoft Excel counts the number of cells within a range that meet a single criterion