How to automatically sum the squares, cubes, etc, of a list of integers?

**Terminatrix** · 06-13-2014, 06:55 AM

Hello.

I have a lot of lists of integers and I want to sum their Xth power automatically, for X = -3, -2, -1, -1/2, 0, 1/2, 1, 2, 3, 4, 5, 6.

For example, take this short list of integers: 1 2 3 4 6 12

The sum of their Xth power must be: 1^X + 2^X + 3^X + 4^X + 6^X + 12^X

How can I do that?

Thanks in advance for your answers.

**XOR LX** · 06-13-2014, 06:58 AM

Hi,

With your values in e.g. A1:A10 and your index in e.g. B1:

=SUMPRODUCT(POWER(A1:A10,B1))

Regards

**Terminatrix** · 06-13-2014, 08:40 AM

Thank you XOR LX, your function worked.

There is just one last little problem: the function doesn't work for X = 0

Basically for X = 0 we should get:
1^0 + 2^0 + 3^0 + 4^0 + 6^0 + 12^0
= 1 + 1 + 1 + 1 + 1 + 1
= 6
It should just give us the quantity of integers present in the list..

**XOR LX** · 06-13-2014, 08:45 AM

You mean you've included some blank cells in the range as well?

Regards

**Terminatrix** · 06-13-2014, 08:52 AM

Oh yes, you're correct. Oops.

Just fixed it, everything is perfect now.

Thanks again for everything.

**XOR LX** · 06-13-2014, 08:55 AM

You're welcome.

Actually if your set-up is such that your range may include blanks, you can use this array formula**:

=SUM(IFERROR(POWER(A1:A10,B1),0))

Regards

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

How to automatically sum the squares, cubes, etc, of a list of integers?

LinkBack

Thread Tools

Rate This Thread

Display

How to automatically sum the squares, cubes, etc, of a list of integers?

Re: How to automatically sum the squares, cubes, etc, of a list of integers?

Re: How to automatically sum the squares, cubes, etc, of a list of integers?

Re: How to automatically sum the squares, cubes, etc, of a list of integers?

Re: How to automatically sum the squares, cubes, etc, of a list of integers?

Re: How to automatically sum the squares, cubes, etc, of a list of integers?

Thread Information

Users Browsing this Thread

Similar Threads

math function cubes & multiple squares

[SOLVED] A list of Consecutive Integers, can I search for missing integers

[SOLVED] A list of Consecutive Integers, can I search for missing integers

A list of Consecutive Integers, can I search for missing integers

[SOLVED] A list of Consecutive Integers, can I search for missing integers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions