Running Total

[francoiscj1]

Each of my inventory items has an individual number and I use that number to auto populate an item and its price.

I would like to be able to search the worksheet for any instance of an item number showing in Column A, then pull the related item numbers in Column C (Qty received), Column D (Qty issued), and Column E (Qty returned) for every time that item number shows and keep a running total for each.

 

[Legacy 436357]

Please attach html of what you would like to accomplish showing examples and results. Someone here can help with the formulas.

I use the Excel Jeannie to attach screenshots of the worksheet.