I'm writing a macro and I would like to use an AVERAGEIF with a dynamic selection instead of a fixed selection.
At the moment I use this in my macro:
AVERAGEIF('sheet1'!R5C11:R10000C11,RC[-1],'sheet1'!R5C12:R10000C12)"
The problem is now, if I have more then 10000 rows, they will not be...