Forum Discussion
Creating a separate table based on two criteria in excel
I am hoping someone can assist with the below example. I have a list of stock orders which are unique and can (in this perfect world model) either be an order to BUY or SELL. Ideally I would like...
HIdbhk852
If you are OK with below slightly different presentation you may use this formula
=IF(AND(COUNTIFS($C$5:$C$23,I5,$D$5:$D$23,"Buy")>0,COUNTIFS($C$5:$C$23,I5,$D$5:$D$23,"Sell")>0),SUMIFS($E$5:$E$23,$C$5:$C$23,I5,$D$5:$D$23,"Buy"),"")
A sample file is also attached for your reference, please let me know if it works for you.
Thanks
Tauqeer
tauqeeracma
Hi Tauqeer,
Thank you very much for the quick response, thats really helpful. And yep it works for my purposes.
Really appreciate the help, was chasing my tail for a while there.
All the best