CONDITIONAL SUM FUNCTION IN EXCEL
Purpose:
During one of our previous posts, we have learnt how to use Sum-if function. This conditional sum function helps us to add the data based on the conditions that are met for more than one column. Unlike Sum-if function, which can add up the data based on the criteria given in one column, conditional sum function can add up the data based on the criteria given in various columns.
Input Data:
Now if you would like to find out the total hours spent and the bill amount for critera where Mr Ashok has spent for Client Gary Ltd for the services Consultancy and Representation, you need to use this conditional sum
How to do
Where do I find “conditional sum” in Excel 2003 / 2007 / 2010
In Excel 2007 and 2010 conditional sum wizard has been done away with. However, we can type the formula as per the format mentioned below:
Syntax of the formula
={SUM(IF (CRITERIA 1, IF( CRITERIA 2, IF( CRITERIA n, SUMRANGE)))}
CAclubindia
