Hey thanks for the reply


Adding the sum to aggregate the sumif doesn't work, hence my posting.

I understand that sumif sums for one specific criteria, and then the sum() function basically aggregates all the conditions.

However, when i do add the sum(sumif()), the formula 'breaks', and every single result in "bought" or "sold" would be the same number.(this is after hitting CSE).
so, despite the fact i understand your explanation to a high degree, it still doesn't work.
and i'm still pretty clueless as to why.(as i said, even when i add the Sum function)

thanks again, Iamhttp