I am now creating an excel file for our inventory temporarily. I want
to check the remaining inventory for each product(PID). So I need to
sum all the quantity with the "In" type of a product in a cell and sum
all the quantity with the "Out" type of a product in another cell.

=SUMIF(A3:A16,A3,C3:C16)
If I only use this statement, I can only know the sum quanitity of a
product without knowing it is "In" or "Out".

So I want to ask is it possible to specify multiple condition with
SUMIF? Or any other solution to my problem.
Thanks

A B C
==========================
PID In/Out Quantity
1 In 2000
2 Out 3000
3 Out 2000
4 In 5000
1 Out 800
2 In 900
1 Out 2000
1 In 1000
2 Out 500
2 Out 3000
3 In 2000
4 In 1000
1 Out 500
5 In 3000

Daniel, use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


"Daniel" wrote:

I am now creating an excel file for our inventory temporarily. I want
to check the remaining inventory for each product(PID). So I need to
sum all the quantity with the "In" type of a product in a cell and sum
all the quantity with the "Out" type of a product in another cell.

=SUMIF(A3:A16,A3,C3:C16)
If I only use this statement, I can only know the sum quanitity of a
product without knowing it is "In" or "Out".

So I want to ask is it possible to specify multiple condition with
SUMIF? Or any other solution to my problem.
Thanks

A B C
==========================
PID In/Out Quantity
1 In 2000
2 Out 3000
3 Out 2000
4 In 5000
1 Out 800
2 In 900
1 Out 2000
1 In 1000
2 Out 500
2 Out 3000
3 In 2000
4 In 1000
1 Out 500
5 In 3000