Results 1 to 5 of 5

SUMSQ for summing the inverse of a series of squared numbers

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    2

    SUMSQ for summing the inverse of a series of squared numbers

    Here is the forrmula I want to solve. I could do this by adding another coulmn but I am trying to keep the sheet simple in appearance and easily allow the addition of more rows to be included in the sum.

    =( 1/(x1)2 + 1/(x2)2 + 1/(x3)2 + ...

    So for a range of cells containing 1,2 and 3, the correct answer is 1.36111.

    My test range of values is K40 to K43 and I have tried:
    =SUMSQ((K40:K42)^-1) and =SUMSQ(1/(J40:J42)) and both give #VALUE in the cell.

    The odd thing is that when I click on the Excel fx button to get function guidance for either of the formulas that I have tried,the correct answer is provided in the popup window. But when I click OK, I get "#VALUE" in the cell.

    Can someone help with this?

    EM.
    Last edited by Excelmon; 09-04-2014 at 07:47 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Summing a series of maximums in a larger series
    By agbaby in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-22-2014, 04:33 PM
  2. [SOLVED] summing a series of numbers in a single cell
    By eddiebautista in forum Excel General
    Replies: 3
    Last Post: 10-28-2013, 03:17 AM
  3. Squaring a series of numbers before summing them
    By itendswithe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2010, 04:22 PM
  4. inverse (flip) column of numbers
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-08-2009, 05:37 PM
  5. Inverse cell selection numbers?
    By dairladada in forum Excel General
    Replies: 4
    Last Post: 11-17-2007, 05:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1