Sunday 11 September 2016

How to do SUMIF with in the same sheet

Problem: I want to sum the quantity of all similar id
If you click on Fx on bar .. it will show formula builder and syntax details.

Problem:  Order id , Quantity

Column A               Column D           Column Results E
ordernumber1              1
ordernumber1               2
ordernumber1               1
ordernumber1                3


ordernumber2                1
ordernumber2                 3

Formula

In results column  field  enter like this.
=SUMIF(A:A,A3,D:D)

First type = and choose SUMIF()

Now Range means Column A .. Just click on top of column to select total column

put,  and now Criteria means Order id  so click on field of Column A

put,  and now sum_range means which column we have to do sum

We have to do Quantity

now click on qty column .. Column D


Adds the cells specified by a given condition or criteria.
Syntax
SUMIF(range,criteria,sum_range)
▪ range: is the range of cells you want evaluated.
▪ criteria: is the condition or criteria in the form of a number, expression, or text that defines which cells will be added.
▪ sum_range: are the actual cells to sum. If omitted, the cells in range are used.

No comments:

Post a Comment