Exempt from AGGREGATE function

[BrianGGG]

Hi. I have a column with at least one thousand rows and several levels of subtotals using the AGGREGATE function.

My problem is: For reasons impossible to explain adequately, there are several rows at various locations in the column that are formulas but should not be counted in the AGGREGATE.
Meaning: They should be exempt from the Grand Total that is determined by the Aggregate function.

I would really prefer not to hard-code the several disjointed arrays to compensate for these values like: AGGREGATE(9,0,A1:A67, A70:A255, A260:A390 ...) etc.
I would prefer to use the entire column in the AGGREGATE and figure out a way to exempt the few places where the total is not appropriate, e.g. AGGREGATE(9,0,A1:A1024).

The exempted cells contain formulas, so I naively tried to wrap them around an AGGREGATE like: AGGREGATE(9,0,B2*C2*D2). Excel was having none of this. I also tried various ways to force the value to be an array value ... but if this is possible I couldn't figure out a way to do it.

So, my question is; Is there any way to turn a formula into a Reference to an Array so that I can use it in AGGREGATE and the Grand Total can ignore these outliers?
I can post an example if my description is not straightforward.


BrianGGG

 

[BrianGGG]

I was able to answer my own question. I was not able to put a formula in AGGREGATE for a Sum, but I was able to do it for the LARGE function.

So, AGGREGATE(15,0,B2*C2*D2,1) returns the value of the function and is exempt from subsequent AGGREGATE sums.