Forum Discussion
Help searching in pivot table
Hello, I would need help with the following table, I will try to explain the clearest way possible, because atm I cannot post an actual example. So I have a list of clients (col A, client accoun...
I honestly didn't understand what's the goal you want to achieve.
If you just want to ignore sells, just use an IF function: IF(type of order="sell";0;volume number).
Then you can sum all buy orders...
If you want to calculate the buy orders ONLY if volume buy > volume sell, then you have to add a new worksheet with the client stated only 1 time and then SUMIF buy and SUMIF sell and do the math.
Else, if I don't understand at all what you need, please explain me with some more examples... sorry