May 05 2022 03:49 AM
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.
Thanks in advance!
May 05 2022 03:58 AM
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.
May 05 2022 04:59 AM
Hi Hans,
Thanks for getting back to me. Here is the Dropbox link
Thanks in advance!
May 05 2022 06:19 AM
Thank you. I have downloaded the workbook.
Can you explain what you want to do - perhaps with an example of the expected output?
May 05 2022 07:05 AM
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?
Thanks in advance!
May 05 2022 07:09 AM
SolutionThat'suseful. In H2:
=IF(A2=A1,"",SUMPRODUCT(($A$2:$A$20=A2)*$F$2:$F$20,$G$2:$G$20))
Fill down.
May 05 2022 07:15 AM
Wow so quick! Thank you very much! It's much appreciated!
May 05 2022 07:09 AM
SolutionThat'suseful. In H2:
=IF(A2=A1,"",SUMPRODUCT(($A$2:$A$20=A2)*$F$2:$F$20,$G$2:$G$20))
Fill down.