Let me explain you my problem:
The AGGREGATE function works well when applied to a range (A) or even to a variable based on a range (B).
However, it is unable to calculate on a calculated variable (C) or even on a calculated array (D).
This seems like an excel bug to me. If it is not a bug, at least it is an annoyance for me.
I work with very big ranges that contain unknown values (represented by #N/A). So I am kind of obliged to use AGGREGATE.
However, if a calculation has to be applied to the range before AGGREGATE is applied (in my case, multiply by 2), then I am forced to create an auxiliary range, and I try to avoid it.
Can you think of any workarounds? Am I somehow mistaken with my conclusions?