In , zvkmpw
wrote:

Still trying to find another way around the ugly INDICRECT
statement. ...

This may be off-topic, but but you might consider something like
=SUMIF(S3:S100000,"<",Q3:Q100000)

Not off-topic, but I don't see how to apply the SUBTOTAL filtering
to it.

/sh