| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Criteria for datbase function in one row? | Excel Worksheet Functions | |||
| criteria function using max | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| include criteria to 'rank based array function' | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Threaded Mode
