Add the values inside the listbox in ascending order

[mody300]

Good morning
How is the process of addition and subtraction based on the name of the item and the type of transaction if it is buying or selling according to the columns inside the listbox and adding them in the last column of the listbox? The process of addition and subtraction is carried out in ascending order by date and in alphabetical order. ?
Find out the type of transaction: buy or sell, column 2,
date, column 3,
Item name, column 4,
Quantity, column 10

The equation I want to show is in the last box of Listing 11

 

[OaklandJim]

I can't promise that I can do this but I'll try. If not me then possibly other people who are more perceptive and/or are smarter about Excel.

If you want assistance you are more likely to get it if you help the helper, so they do not need to guess about or recreate your data.

If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the Mr Excel message area. Make sure that other people can access the file!

Or, consider sharing relevant data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. See XL2BB - Excel Range to BBCode for details.

It also helps if you show us the result that you need.