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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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?
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
Hi internet peeps. I am stuck i don't know what code to use so i can search the same column twice for 2 different keyword and then copy data from...
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.