Subtotal on filtered list multiplied by corresponding %

[mountainman88]

I have a column of percentages and a column of numbers with an autofilter above both.

Above the column of numbers I need a formula that shows a single total of only the filtered numbers displayed but multiplied by the corresponding percentage. This total should be dynamic and changed based on the filtered numbers shown.

ive tried using {subtotal(109,A:A)*subtotal(109,B:B)} as an array function but no luck

thanks

 

[Toadstool]

Add a worker column for the multiplication then AGGREGATE SUM that column

Book1
	A	B	C	D	E
1	Numbers	Percent	Mult		34
3	20	5%	1
5	40	11%	4.4
7	60	17%	10.2
9	80	23%	18.4
Sheet1

Cell Formulas
Range	Formula
E1	E1	=AGGREGATE(9,1,$C$2:$C$15)
C3,C9,C7,C5	C3	=A3*B3

 

[mountainman88]

Thanks for the response but I am looking for a solution that likely uses arrays or sum product that will perform the calculation in a single cell and creates no other columns.

in addition, your solution does not appear to fulfil the requirement of summing only visible unfiltered rows.

 

[Toadstool]

I understand your wish to avoid a worker column but it would appear to me that 34 should be the answer for that example.
What number would you expect for the unfiltered A and B columns?

 

[mountainman88]

I understand your wish to avoid a worker column but it would appear to me that 34 should be the answer for that example.
What number would you expect for the unfiltered A and B columns?

Ok got it, the filter part works but I do need a method with no helper columns thanks