Hello,
First off, thanks for taking the time to read this and offering any help that you can provide.
I have a worksheet that built for pricing equipment out. Each item is broken out according to what type of accessories it has, therefore there are often times when there are multiple rows for each item (ie 5 rows for number 1). Each line has a total cost for the accessory. I want to be able to have a macro add the costs from each row and spit out a total for each item in a column to the left of the base item (each row either has a 'B' or 'O' to tell another part of the worksheet that this is a 'base' item or an 'option')
I'll attach a small example of my worksheet.
Thanks for any help you may be able to provide!
example 1.1.xlsx
Edit- updated file to reflect what I think was requested.
Bookmarks