# summation

1. ### Summation Part of Erlang C Formula

What would be the best way to write the below summation into a formula in excel? It is part of the Erlang C formula and I am looking to calculate it a number of times. Right now I have a table that changes based on the "A" value then I use a vlookup based on "N-1" to go grab that sum. I...
2. ### Recording a Summation Macro

Hi I am reading a course outline and it says students will learn Recording a Summation Macro Recording Consolidations Recording Divisional Macros My question, what does summation/divisional/consolidation macros mean? source...
3. ### Adding Multiple Columns and Multiple Rows - Using specific criteria

Hi Guys Just curious if someone knew had to do a complicated "sumif" calculation where you take the criteria in a list from the columns and the rows. What I am trying to do is add up all the quarters in a specific year (say in this case 2018) and add only 2018's quarters along with the...
4. ### Sumproducts with return of text

Hello, I've been using this formula: =SUMPRODUCT(SUMIF(INDIRECT("'"&Buyplan&"'!\$A\$1:\$A\$10600"),\$A7,INDIRECT("'"&Buyplan&"'!F\$1:F\$10600"))) and notice that doesn't return any text, I still need to get the summation across different sheet, but there are instances it has a text, text contains...
5. ### Tricky summation

Hello, I am needing a tricky (for me) summation of a row. Row 1 - I have a very long row of percentage values ranging from 0 to 100. (Column A blank) Row 2 - I have a very long row of values ranging from 0 to Infinity. (Column A Blank) Cell B4 - I have a fixed value of 0 to Infinity. I need...
6. ### Calculations using Sigma Summation

Hello everybody, I am working on a thesis paper and have an equation that I need to be able to use in excel. I have no idea how to design an excel equation to match what I see. I thing that this will be an array function of some sort. The following are the parts of the equation: C = COST...
7. ### Can I refer to a column by its Named Range?

On my worksheets, I have named some columns using the Name Manager. In VBA, I was hoping to be able to refer to the columns by the names I gave them, but I can't seem to figure out how to do it. Here's a test sub I wrote to try to figure it out. Sub Test() Dim Summation As Integer...
8. ### Counting Multiple, Inconsistent Order Lengths as a Singular Order

I'm currently trying to sum up the total number of items ordered within a single order. Currently, I have tried to individually go through and find the number of repeated order numbers in order to find how many lines of items I need to sum into a singular order number. What I would like to do...
9. ### Sigma Summation in Excel

I am looking for some advice on how to do a Sigma calculation in Excel. I have quite an elaborate equation that calculates rebate percentages on casino bets. I'm able to calculate the equation for one round of betting, but when it gets to more than two rounds of betting the equation gets bigger...
10. ### Tree sumation in Excel (with or, if possible, without VBA)

Hello everybody, I have to model branched water supply network showed in picture attached here https://goo.gl/jJFhMx. Node numbers are written in brackets, while pipe numbers are written in red and rectangled. Water demand is defined in nodes and marked with an arrow. So, input data are pipe...
11. ### Pushing parameters into a pivot table

If I have a list of weeks 1,2,3,4,5,6,7,8,10 I want to be able to type a 3 in the workbook and the labels and summation in the pivot will change to past due,4,5,6,7,8,10 And if I type a 5 in the workbook, the labels and summation in the pivot will change to past due 6,7,8,10 Is this possible?
12. ### Graphing Data in Excel

I have the following formula that I would like to graph: G(t) = G_r +(G_g-G_r) * summation from (i=1 to N) g_i *e^(-t/tau_i). G_r and G_g are both constants and can easily be defined in a cell tau_i and g_i are 24 sets of data given. t is a variable. The goal is to graph G(t) vs t and G(t) vs...
13. ### VBA: "n" summation tiers

Hello - I'm extremely new to VBA, but have had to learn it at a relatively high level pretty fast, so forgive me if this is a simple question. There are lots of gaps in my understanding. I have been working with an equation that involves two levels of summation, see formula (a) below, but today...
14. ### summing the numeric values of all cells but equals to zero if any cell contains any text...

Hello to all, I have a little problem in using summation of the values which in normal case results in adding all values but if any one of the cell contains a text (any text, not specific) then the summation should result to zero. I have applied this formula for values in cells from A2 to D2...
15. ### Question regarding difficult vba function

Hi. I am pretty new to VBA, and have been struggling with a function for a while. I am trying to add two cells from two different sheets, and place the subract in a specific cells on a sheet. I am doing this about 600 times, so I probably need a loop. I know how to do it if only pasting the...
16. ### SUM Multiple Pages Dyamically Using INDIRECT

Hello, So I am looking to create an equation that will add multiple pages together based on a pre-selected range by user. My first thought was since all the data on each tab is not used, i would set up an Indirect equation to set get only the necessary data. I have this so far ...
17. ### Summation not including single digit and double digit numbers

Greetings everyone, I have 2 spreadsheets that I'm using...one is to cut data from and the other is to paste data into. I am transferring 2 columns of numbers with each column having about 200 rows, between the spreadsheets. I am only trying to sum these 2 columns together, but for some...
18. ### Excel macro - data transfer. is this possible?

So i am wondering if there is a macro that willallow me to type in on one sheet a list as follows (example) <!--[if !supportLineBreakNewLine]--> <tbody> component x 02Jul13 p component y 02Jul13 q component z 04Jul13 r component x 02Jul13 s </tbody> etc <!--[endif]--> and then...
19. ### Dynamic Array Summation

Hi all, I am looking forward to see your suggestions for my excel problem: I have consecutive arrays all of which are in descending order in Column A. Each array starts from a random number and always ends up with 1. Each array is seperated from other by random variables. For each number in...
20. ### easy one, thank you: =SUM()

Hi. Hope you can help. I think this may be easy for you, but appreciated nonetheless! When I drag down a column of numbers, say, 4 7 2 9 and then hit the "E" (Sum), the last item (in this example the 9) changes to "=SUM()", instead of calculating and putting the sum on the following empty...

### This Week's Hot Topics ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back