I have a range of values, for example R11:R25, for which I need to reciprocate and take the average. I need to do this all in one step, using a function, and the range may contain blank cells. If I try to reciprocate the blank cells I get a DIV/0 error so I'm trying to use the aggregate function as follows to work around that:

=AGGREGATE(1, 6, 1/(R11:R25)).

Based on my understanding this should take the array of values R11:R25; reciprocate them and then, ignoring errors, calculate the average. However, the function isn't working as expected and is giving a #VALUE! error. Is anyone able to explain why this doesn't work and how I might achieve my stated goal?