View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
khaled shaheen khaled shaheen is offline
external usenet poster
 
Posts: 14
Default Sum If function with 2 criteria

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