up vote 1 down vote favorite
share [g+] share [fb]

I can do this creating a new column B where =POWER(A1, 10) and then I get the result with =AVERAGE(B1:B2). But how to do that without a new column?

link|improve this question
94% accept rate
feedback

3 Answers

up vote 2 down vote accepted

You can use an array formula to do this. Let's say your numbers to set to a power are in cells A1 to A9, you can find what you want by entering the following formula into a cell:

=AVERAGE(POWER(A1:A9, 10))

When you are done entering the formula, you need to press Ctrl+Shift+Enter to enter it as an array formula.

link|improve this answer
The only problem is that empty lines aren't ignored – Jader Dias Jul 29 '11 at 15:58
feedback
up vote 0 down vote

I would just create the new column and hide it. Or put it on another sheet.

link|improve this answer
feedback
up vote 0 down vote

would this work as an array formula for you? it resolves the empty rows issue you mention

=POWER(A1:A10,10)/COUNTA(A1:A10)
link|improve this answer
I think you left out the SUM function: =SUM(POWER(A1:A10,10))/COUNT(A1:A10) – Excellll Aug 2 '11 at 13:45
@Excellll thanks, you are correct – datatoo Aug 2 '11 at 15:46
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.