"khaled shaheen" wrote:

Hi all,
First here below my example in order to be understood easily
Database:
Stock ticker Quantity Buy/Sell
HRHO 1000 Buy
ESRS 500 Buy
HRHO 500 Sell

Inquiry:
Ticker Total Bought Total Sold
HRHO ??? ???

I want to know how to get the total quantity sold for HRHO alone, by using
Sumif function it gives me total quatity (bought + sold) for HRHO together.
Appreciate your support,

Khaled
Make new colum with with the ticker and the buy/sell with and function
like this : HRHO&buy (you can name it "ticket&kind") an hide it
use this colum in the sumif function istead of the ticket colum with the
criteria "hrho"&"buy"
I hope it helps