Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif function with two criterias
I have some stock names in Column A, I have some "Buy" or "sell" in column B,
I have Transaction amount written in Column C I will specify the stock name in Cell D1, I want the total "Buy" amount for that particular stock in Cell D2. For this there should be a function in Cell D2 which adds values in Column C if the Stock name in Column A is equal to Cell D1 and has "Buy" written in Column B Example GESCOR Buy 250 LARTOU Sell 40 GVKPOW Buy 1000 ENGIND Sell 101 RELCOM Sell 200 TATPOW Sell 10 RELIND Sell 10 TISCO Sell 350 RELCOM Sell 100 SESGOA Buy 250 TATPOW Sell 20 INFTEC Sell 40 RELPOW Buy 200 RELCOM Sell 100 TATPOW Buy 25 BHATE Buy 35 ENGIND Buy 101 TATPOW Buy 25 RELCOM Buy 100 Cell D1-- If I input TATPOW then Cell D2 should give me value 50 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with 2 criterias | Excel Discussion (Misc queries) | |||
How can I have 2 criterias within sumif function | Excel Worksheet Functions | |||
Sumif with two criterias | Excel Worksheet Functions | |||
I want to use the same function as SUMIF, but for two criterias | Excel Worksheet Functions | |||
SUMIF with 2 criterias | Excel Worksheet Functions |