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