SUBTOTAL with values returned by INDEX

[Yamezz]

I have a sheet with dates in column A and prices in column O.
Cell O1 contains the formula =SUBTOTAL(9,O3:O100000).
Prices in column O are returned from the product of column N and an INDEX formula.
The INDEX formula computes correctly, but the SUBTOTAL formula fails to include prices derived from the INDEX formula.
Cell formats are set to currency and adding =VALUE() to the index formula does not help.
If I overwrite the prices returned by INDEX with the actual value then SUBTOTAL(9, begins to work.

How can I get SUBTOTAL(9, to work correctly with the INDEX results?

Thanks.

 

[Skybluekid]

What is driving the INDEX function, in order to return the row? You will need to force INDEX to return a reference and not a Value. For example, using O3:INDEX(O3:100000,15), will return O3:O18. This will the allow the Subtotal to calculate.

 

[Yamezz]

Here's an example of the formula in O11069. Column L holds the type of product and column N holds the amount of that product to arrive at a total price (derived from the InputCosts table), which in this case is displayed in O11069 correctly as $5.00

=N11069*(INDEX(InputCosts[Cost],AGGREGATE(15,6,(ROW(InputCosts[Cost])-ROW(InputCosts[#Headers]))/((InputCosts[Item]=L11069)*(InputCosts[Date]=AGGREGATE(14,6,InputCosts[Date]/((InputCosts[Item]=L11069)*(InputCosts[Date]<=A11069)),1))),1)))

I'll admit, I don't fully understand the formula above, as it was adapted from something I found online posted by someone far smarter than me!