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.
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.