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.
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Pl see attached file with formula
IN G2, then dragdown.
Please Login or Register to view this content.
using a helper column
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks