Creating a find, match, lookup, and return formula

[Pestomania]

I am struggling to get a formula to work that allows me to find a value "A" and return all valuations based on that.

In the below example, I have provided some details but I need to understand how to get a count of Program 1-4 based on the "A" and then multiple those counts by the appropriate decimal value.

Not sure this makes a lot of sense, but please let me know.

Prestons Playground for Modeling.xlsx
	A	B	C	D	E	F	G	H
1	Program Name					Decimal Point
2	Program 1	A			Program 1	0.5
3	Program 1	B			Program 2	1
4	Program 1	A			Program 3	0.75
5	Program 2	A			Program 4	0.3
6	Program 2	C
7	Program 3	B
8	Program 4	D
9
10	A	Program 1	0.5	1		Here is my problem: A should be returning total of 2 (2 Program 1 & 1 Program 2) My Index Match only finds the first instance that "A" appears, but I need to find all instances that it appears and multiples the count by program by decimal point.
11	B	Program 1	0.5	0.5
12	C	Program 2	1	1
13	D	Program 4	0.3	0.3
Sheet3

Cell Formulas
Range	Formula
B10:B13	B10	=INDEX($A$2:$A$8,MATCH(A10,$B$2:$B$8,0))
C10:C13	C10	=SUMPRODUCT((B10=$E$2:$E$5)*$F$2:$F$5)
D10:D13	D10	=COUNTIFS($A$2:$A$8,B10,$B$2:$B$8,A10)*C10

 

[Bedlam]

In cell B11 type =SUM(SUMIF($E$1:$E$8,TRANSPOSE(CHOOSECOLS(FILTER($A$2:$B$8,$B$2:$B$8=A10),1)),$F$1:$F$8))
It gets 2

 

[Eric W]

Try this:

Book1
	A	B	C	D	E	F
1	Program Name					Decimal Point
2	Program 1	A			Program 1	0.5
3	Program 1	B			Program 2	1
4	Program 1	A			Program 3	0.75
5	Program 2	A			Program 4	0.3
6	Program 2	C
7	Program 3	B
8	Program 4	D
9
10	A	2		Program 1 X 2, Program 2 X 1
11	B	1.25		Program 1 X 1, Program 3 X 1
12	C	1		Program 2 X 1
13	D	0.3		Program 4 X 1
Sheet1

Cell Formulas
Range	Formula
B10:B13	B10	=SUM(COUNTIFS($A$2:$A$8,$E$2:$E$5,$B$2:$B$8,A10)*$F$2:$F$5)
D10:D13	D10	=LET(c,COUNTIFS($A$2:$A$8,$E$2:$E$5,$B$2:$B$8,A10),TEXTJOIN(", ",1,IF(c,$E$2:$E$5&" X "&c,"")))

The B formula just gives the result, the D formula is if you want the breakdown.