ADDING UP DATA USING SUMIF FUNCTION IN EXCEL
Purpose:
To add up the data available in an array based on a particular field.
Input Data:
Now if you would like to add up and find out how much sales has the salesman “A” or “B” or “C” done in totality. This can be done using pivot table as one option. However let us assume that you wish to calculate their incentive based on the total sales made, you need to use “Sumif” formula function.
How to do
Where do I “Sumif” in Excel 2003 / 2007 / 2010
Since it is a formula, we need to type the same in the format mentioned below
Syntax of the formula
=SUMIF (LOOKUPRANGE, LOOKUPCELL, SUMRANGE)
FORMULA PART |
DESCRIPTION |
LOOKUPRANGE |
This is the column that contains the data that you want to use to filter. For e.g. in our example the column containing Salesman details viz, Column B |
LOOKUPCELL |
This is a particular cell where you want to find out the output for that. For e.g. you want to find out the sales value of a particular saleman. So we should have that salesman name keyed in a particular cell, which should be used in this formula |
SUMRANGE |
This is the column that you want to addup. In our example, this would be column “C” and “D” |
Hence we should have a small table made as shown below and then execute the formula
Click Here To Continue Reading
CAclubindia
