Formula, add data if co

[The Power Loon]

I have an issue i'm trying to work out. Whenever the term "addon" is found in the Description column, I want its "Price" added in the Extra column where ever the Group ID is the same.

Below, you can see that $50.00 had been added in the Extra column for every row with the same GroupID as the "addon".

Description	Group ID	Price	Extra
product 1	hhh	$3,467.00​
addon	yyy	$50.00​	$50.00​
product 2	yyy	$454.80​	$50.00​
product 3	yyy	$67.99​	$50.00​
product 1	kkk	$3,467.00​
product 4	kkk	$456.00​

Unfortunately, I haven't been able to work out a functional formula. Is this even possible outside of VBA?

 

[felixstraube]

What if there is more than 1 addon row with the same group ID and differente Price? Or is this combination not possible?

 

[felixstraube]

If only one possible result then try this in D2 and drag down:

=IFERROR(FILTER($C$2:$C$26,($A$2:$A$26="Addon")*($B$2:$B$26=B2)),"")

 

[dreid1011]

If only one possible result then try this in D2 and drag down:

=IFERROR(FILTER($C$2:$C$26,($A$2:$A$26="Addon")*($B$2:$B$26=B2)),"")

View attachment 104892

You can just add SUM in there to get multiple addons if they should be combined:

Book1
	A	B	C	D	E
1	Description	Group ID	Price	Extra
2	product 1	hhh	$ 3,467.00
3	addon	yyy	$ 50.00	$50.00	$ 125.00
4	product 2	yyy	$ 454.80	$50.00	$ 125.00
5	product 3	yyy	$ 67.99	$50.00	$ 125.00
6	product 1	kkk	$ 3,467.00
7	product 4	kkk	$ 456.00
8	addon	yyy	$ 75.00		$ 125.00
Sheet7

Cell Formulas
Range	Formula
E2:E8	E2	=IFERROR(SUM(FILTER($C$2:$C$26,($A$2:$A$26="Addon")*($B$2:$B$26=B2))),"")

 

[felixstraube]

Sure. Or maybe he wants the max or min value... dunno. that's why I asked.

 

[dreid1011]

Sure. Or maybe he wants the max or min value... dunno. that's why I asked.

And now they have both options if they so decide to use them

 

[felixstraube]

They have

 

[The Power Loon]

You can just add SUM in there to get multiple addons if they should be combined:

Book1
	A	B	C	D	E
1	Description	Group ID	Price	Extra
2	product 1	hhh	$ 3,467.00
3	addon	yyy	$ 50.00	$50.00	$ 125.00
4	product 2	yyy	$ 454.80	$50.00	$ 125.00
5	product 3	yyy	$ 67.99	$50.00	$ 125.00
6	product 1	kkk	$ 3,467.00
7	product 4	kkk	$ 456.00
8	addon	yyy	$ 75.00		$ 125.00
Sheet7

Cell Formulas
Range	Formula
E2:E8	E2	=IFERROR(SUM(FILTER($C$2:$C$26,($A$2:$A$26="Addon")*($B$2:$B$26=B2))),"")

It works. Thank you for your time on this.

 

[dreid1011]

It works. Thank you for your time on this.

You're welcome, and happy to help.