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
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
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:![]()
x --- f(x) 1 --- =$A$116*A2*... --- note the use of absolute and relative references to make copying easy =A2+1 --- copy of B2 copy of A3 --- copy of B2 and so on until the desired x is reached "total" --- =sum(A2:A100)
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks