Excel SUM Function Tips

SUMPRDOUCT Function In Excel

SUMPRODUCT is yet another function that comes to rescue, whether we want to validate a criteria or want to sum against a list of requirements

Understanding And Doing Better With SUMIF Function

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).

How To Sum Using Logical Functions - An Example Of Using AND () And OR() In Excel

MS Excel offers seven logical functions, today we will discuss how to use AND () when summing up values.

The Importance Of INDIRECT Function

INDIRECT Function yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell. 

Top Formulas for Analysts

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.

Use Cluster Values to Generate Sequence Numbers

If you are wondering if it is possible to create sequence numbers from clustered values, then you should definitely consider reading ahead to find out more

How to Use Sumif

The SUMIF function is used to conditionally sum values based on a single criteria.

How to use SUMIFS (Multiple Criteria)

The SUMIF function is used to conditionally sum values based on certain criteria. Another version of that function is SUMIFS

How To Use SUMIF Function (WS)

The SUMIF function is used to conditionally sum values based on a single criteria.  The Syntax of this SUMIF function can be explained as follows:

Sum opeation of wanted cell in a list

Use SUMIF() functions.