SOLVED

New Contributor

# Pricing of components costs as part of a bundle

Hi Everyone,

I'm hoping my subject makes a bit of sense but here goes.

I want to find a way/formula that can help me group the costs of each individual item that's part of a bundle.

I have all the data such as bundle codes, individual product codes etc.

The bundle codes are duplicated depending on the number of components in said bundle. For example, a bundle has 3 items, the data range duplicates the bundle code 3 times for each individual product. Not sure if this info helps.

6 Replies

# Re: Pricing of components costs as part of a bundle

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

# Re: Pricing of components costs as part of a bundle

Hi Hans,

Thanks for getting back to me. Here is the Dropbox link

https://www.dropbox.com/scl/fi/oyfy84ld6duipiltmptgv/Sample-data.xlsx?dl=0&rlkey=tsfwz79h626xd5eoej0...

# Re: Pricing of components costs as part of a bundle

Can you explain what you want to do - perhaps with an example of the expected output?

# Re: Pricing of components costs as part of a bundle

Of course, that would help!
So basically, I need to know if there's a way or formula I can put in column H that compares the references in column A or B and totals everything in column F as long as the references in A or B are the same. Hopefully that makes sense?
The end result I'm aiming for is to find out the profit margin of a bundle, taking into account the cost prices of each individual item in the bundle.

Something that looks like this at the end?

best response confirmed by Pro-Pix (New Contributor)
Solution

# Re: Pricing of components costs as part of a bundle

That'suseful. In H2:

=IF(A2=A1,"",SUMPRODUCT((\$A\$2:\$A\$20=A2)*\$F\$2:\$F\$20,\$G\$2:\$G\$20))

Fill down.

# Re: Pricing of components costs as part of a bundle

Wow so quick! Thank you very much! It's much appreciated!