# Add The Squares

Mar 24, 2009How would I add the squares of cells A1:ZZ1 or A1:A1000, without having to do

=SUM(A1*A1+B1*B1+C1*C1... etc

This is a basic example of what I actually want to do, but is essentially the same problem.

How would I add the squares of cells A1:ZZ1 or A1:A1000, without having to do

=SUM(A1*A1+B1*B1+C1*C1... etc

This is a basic example of what I actually want to do, but is essentially the same problem.

ADVERTISEMENT

I need to do a Sum of the Squares of the first 'n' Natural

Numbers. Something like:

function_name(n)

If 'n' is 8 say, then the function would return 204.

Thats 1*1 + 2*2 + 3*3 + 4*4 + 5*5 + 6*6 + 7*7 + 8*8

Likewise if 'n' is 6 say, then the function would return 91!

I'm trying to do a sum of squares calculation, between and within groups, across multiple columns.

I llike this to occur automatically when I input the data. Where I've running into difficulty is calculating the mean of each group(without sorting and manually selecting). See sample of data below:

Typestdby_currentrx_currentNormal0.141116170.171218Rework0.140827160.170686Normal0.140360580.172524Rework0.136112870.167756Normal0.141427740.170232

Note that there are more columns of different parameters I've just inserted two for demonstation

I would like to:

1-Make Rows & columns 1/4" X 1/4"

2-Be able to enter dimensions into an input box that would then draw a square(or rectagle) with the inputed dimensions in INCHES.

Further to here where exactly in options do I delete all of these little yellow squares with script signs in them which are invading my spreadsheet?

View 14 Replies View RelatedI 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?

In a userform i have created an textbox. The user types some text in it and after clicking an OK-Button this text must be copied to a cell To allow multiple lines (enter = new line in textbox) i have changed the textbox property EnterKeyBehavior to True. The problem is that after copying this textbox1.text to a cell in see square blocks in the cell.

line1[]

line2

instead of

line1

line2

I use the following code to copy the text into a cell:

Private Sub CommandButtonOK_Click()

Dim TextboxText As String

TextboxText = TextBox1.Text

ActiveCell.Value = TextboxText

Unload Me

End Sub

how to avoid this [] (should be like alt-enter in a cell)

Copyrights 2005-15 www.BigResource.com, All rights reserved