Calculate sum over power of a range of values in excel?

Question

I have Several Numbers in A1 through A100. I have also a number stored in another cell, D1. Now I want to calculate

=sum(power(a1,d1), power(a2, d1), ....... power(a100,d1) ).

How can I do that in short form of excel function? I have come across sumsq function that can evaluate sum of square values in a range. But I want to generalize for power n, not just 2.

Answer 1

Use the Array formula:

=SUM((A1:A100)^$D$1)

or

=SUM(POWER((A1:A100),$D$1))

Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key.