Cell A2 is a product description. Cell B3:B5 contain the individual transactions, B6 is the total of B3:B5. I would like the totals (B6) to calculate in a cell adjacent to A2 (description). The problem is the data extracted is an inconsistent number of rows; sometimes it is 2 rows with a total and sometimes it is a single row without a total. My file is extracted from another program.
I've attached a sample workbook. The cells referenced above do not refer to the cells in the workbook.
Bookmarks