You would need to EDIT and change your title
have a read if rule 1 here
http://www.excelforum.com/forum-rule...rum-rules.html
Your post title should accurately and concisely describe your problem, not your anticipated solution.
I know the moderators do monitor and post for people to change title
so i have done this in two parts
in AC2
=IF(AA2="sell",AB2*-1,AB2)
I wanted to change the value you had in AB to show -ve for sell and + for buy
and then in AD2
=IF(SUMIF(E:E,E2,AC:AC)<0,"Net Sell","NetBuy")
find out if the overall number is less than zero or greater than = to zero
not sure if you want to class 0 as a different type
Bookmarks