+ Reply to Thread
Results 1 to 2 of 2

Summation in Excel

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    hawaii
    MS-Off Ver
    Ecxel in Windows XP
    Posts
    9

    Summation in Excel

    How do I do a summation in Excel? I want to calculate the function: Σ (A116*X)*B116*C116*E116*(365/D116)

    Where n=1, the upper limit is the value of a cell, and X is a value from 1-the value in a cell.
    Thank you!
    Dan

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Summation in Excel

    I'm not certain I fully understand the summation you want (you mention n, but I don't see an n in the function, and so on).

    Basic strategy I almost always use for a summation:

    1) Put any constants into cells
    2) Create a column for the counter variable (X in this case??)
    3) Create a column to calculate each addend for each value of the counter variable
    4) Use a =SUM() function a the top or bottom of this column to sum up the addends.

    So it will look something like:
    Please Login or Register  to view this content.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMMATION on excel
    By Rosiel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 12:50 PM
  2. the textbox's value and the excel cell's value summation
    By bskaa in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-21-2013, 07:41 AM
  3. Excel SUMMATION macro
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2011, 01:55 AM
  4. Large scale summation using Excel for Mac
    By SAP2112 in forum Excel General
    Replies: 1
    Last Post: 12-12-2008, 05:40 PM
  5. Fast Summation in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-08-2007, 09:34 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