Make A Calculation(addition) And Use The Answer To Multiply Against Another Addition Calculation
make a calculation(addition) and use the answer to multiply against another addition calculation....
The sum of (Monday!A1:A4) multiplied by the sum of (Monday!B1:B4) plus (Tuesday!A1:A4) multiplied by the sum of (Tuesday!B1:B4) and so on.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Addition Calculation Not Giving Correct Answer
I have a workbook with calculations for a sale less the assorted fees and at the end giving the final amount from a sale. I have noticed that some of the rows are not giving the correct amount in them. In other words the addition of some columns in that row are not adding up correctly. It is only off by 1 cent (either over or under), but I can't figure out why. I have the feeling that I am going to want to kick myself when someone explains this to me (I just know that I know the answer but for the life of me I can't right now).
View Replies!
View Related
Make #NAME? Go Away And Calculation Come Back
=IF(OR(J4="",K4=""),"",NETWORKDAYS(J4,K4,Holidays!Z29:Z39)-1) I have this formula in Column L. The calculations are working fine and I close the file. After I email the workbook from one computer to another and then resave it, every row in Column L that has the formula turns to #NAME? Do you know why this is happening?
View Replies!
View Related
Addition Of Cells
I wanted to have the weeks of the month down one column = 52 week. down the next column I have different amounts of money in that week. some months have 4 weeks and other have 5. I wanted a program to say: If you see a month "x" look at the next column and take that amount. Then on the next row you have month "x" again (week 2) go to the next column and take that amount and add it to week one. And so on until all 4/5 week are added to give on result. Then the same for the next month... month amount/week amount/month 05-Mar 0 12-Mar 70 19-Mar 210 26-Mar 350 1050 02-Apr 420 09-Apr 455......
View Replies!
View Related
Addition In Base 6
I've got a column of numbers that represent the number of overs bowled in games of cricket. Whilst these are whole numbers (eg. 34 overs + 34 overs) the addition isn't a problem, but when they are incomplete overs (eg. 34.4 overs + 34.5 overs) then the addition if out of kilter as it sums them in base 10, and not in base 6. (As there are six balls in an over, not ten for anyone who doesn't know!)
View Replies!
View Related
Sumproduct - Addition By Name
I need to C8 - C19 only to add up jobs won by andrew (in current orders). It needs to be month specific. what i mean by that is I need the formula to do what its doing now (adding up the jobs by and putting the totals into the according cell depending on what month they were won.
View Replies!
View Related
Addition Formula
I am a new excel user. I a trying to write a certain formula but am having trouble. I want to write the formula to add a column of numbers, say H-10 through H-15. Each cell will have a number in it, but I want only to add the cells if the cell precedding it in the G-10 through G-15 Collumn is blank. For example if cells G-12 and G-14 have an "X" in them, then I do not want Cells H-12 and H-14 to be added. I only want the formula to add cells H-10,H-11,H-13, and H-15. I used just 6 cells for example, the column of cells to be added will be a lot longer.
View Replies!
View Related
Vlookup & Addition
I have multiple ranges in a spread sheet. I am trying to write a formula that will go out to each range in succession and look for a part number, upon finding return a quantity and them move on to the next range duplicating the above process. The formula should tally the grand total of all numbers found. I have it working except that not all of my items are in all ranges. If the item that I am searching for is in all ranges my formula works but if there is one or more of the ranges that doesn't have that particular value it returns an #n/a instead of totalling those that do have it. If I use a true instead of false in my [range_lookup] I get an incorrect answer. My formula for a given cell is listed below. This is with the true argument which does not work....
View Replies!
View Related
Addition Of The Values In The Cells
I AM HAVING DATA OF 210 BRANCHES OF DIFFERENT ITEMS. EACH BRANCH HAS AROUND 100 TO 150 ITEMS. I WANT TO ADD THE VALUES OF EACH BRANCH AND I HAVE TO GET THE GRAND TOTAL VALUE IN A SINGLE SHEET. SUPPOSE IF ADD E10+E210+E350+E470 LIKE THIS AFTER SOME pLUSES I WILL GET THE FORMULA RANGE IS OVER. IS THERE ANY METHOD OF ADDING 210 BRANCHES ITEMS
View Replies!
View Related
Algorithm For Addition (operation For Each ID)
Have an excel table with following data: - ID - number of bottles - number of bottle crates (there are 20 bottles in one one bottle crate) 201688194000bottles 20168819200crates 2016883812000bottles 20168838600crates 201688396400bottles 20168839320crates 201688809000bottles 20168880600bottles 20168880480crates................... I need to write a macro which will do this operation for each ID: (bottles/20)-crates = x and if "x" is not 0 then write down the value of "x". There are two points I would like to point out: - One ID may contain 3 or more rows (see 20168880) - The macro will work with hundreds IDs so the algorithm should be fast (but it is not necessary)
View Replies!
View Related
Multiplication/addition Function
I obviously know less about functions than I thought I did. I've got the attached spreadsheet set up except getting totals at the bottom. The production total L44, would be column A multiplied by the quantity entered in columns L and summed. Same for Total SF, square footage in column B times quantity in L and summed at the bottom. This would continue daily, needing sums under each column.
View Replies!
View Related
Simple Conditional Addition Function
I imagine this is a simple conditional SUMIF function. I'd like a cell to add values in e.g. column "d" when that row meets certain criterion in column "a". In other words, I have a column that has times recorded in minutes, and another that says a person's name which correlates with the times. I'd like a cell on another sheet to give a total sum of minutes for each person. Ideally, part of the function would translate the minute count into hours/minutes, but I think I can figure out how to do that by changing the format in the cell...
View Replies!
View Related
Function Of Addition With An Only Conditional Criterion
I behind developed to a time a function of Addition with an only conditional criterion. I would like to extend at least for three criteria, this function I function accurately as the function SUMPRODUCT alone that done in VBA. Function VlookupAllSum(name As String, IntervalSearches As Range, IntervalReturn As Range) As Variant ' as integer para valores até 32.767 Dim Valor, Nome Dim lin, col As Integer Dim Total Application.Volatile lin = 1 col = lin For Each Nome In IntervalSearches If Nome = name Then Valor = IntervalReturn(lin, col)................
View Replies!
View Related
Addition/Subtraction With Menu Selection
Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options. If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?
View Replies!
View Related
Sumproduct, Skipping Columns, Addition
I have Names in column A, Data in Column B. Example A1 John B1 1000 C1 5:32:05 A2 Jim B2 500 C2 5:56:55 A3 John B3 600 C3 6:45:65 A4 Bill B4 300 C3 7:21:05 In another column I have the names of all the possible people that I will need data from and next to them I will need a formula to tabulate all their totals from column B and then another formula that will skip B and total column C's total.. I have a formula that I used from awhile ago when I needed to offset the data but I can't figure out how to just take the data to the right of it and then another formula to skip column B. Here is my old formula =SUMPRODUCT(($A$1:$A$291=G14)+0,OFFSET($B$1:$B$291,1,0)+0)
View Replies!
View Related
Fill InThe Blanks Addition
I have some great code that HalfAce provided a while back that I think will fit a project I am working on, but I can't see how to modify it to fit this one. I need to have it look at a location and provider and find the most "common" date. Then for that criteria fill in the lines with no dates with that "common" date. Here is the code that I need to modify for this Sub FillInTheBlanks() Dim LstRw As Long, _ DescRng As Range, _ AccntRng As Range, _ Desc As Range, _ Accnt As Range LstRw = Cells(Rows.Count, "B").End(xlUp).Row Set AccntRng = Range(Cells(2, "B"), Cells(LstRw, "B")) Set DescRng = Range(Cells(2, "I"), Cells(LstRw, "I"))
View Replies!
View Related
Calculator Formula For Addition Via Columns
I would like to know the calculator formula for addition via columns. Eg 1. If i were to place 135 into Column A ; 12.95 into Column C ; i would need to yield a result of 147.95 Eg 2. Place 189 into Column A ; 12.95 into Column C i would need to yield result of 201.95 and so on. in the attachment is the sample file.
View Replies!
View Related
Addition Of Values In A Single Cell
see the attached sheet. It already has some example....I need the result of the addition in the cells of column F, at the side Say column G, in the coressponding row. e.g for cell F9, I need the result in G9, and so on. For testing, step 1. Select M+R in Col "TOI", enter some value in the pop up. step 2. Again select M+R in "TOI", enter some value in the pop up. the Col F will have some additions (e.g 1+2), for which I need the result in the corresponding next column. i.e col G.
View Replies!
View Related
Update Csa Formula With The Addition Of New Rows
I am working on a spreadsheet that matches each cell in Column B (text) with the data (text) in a constant cell; if there is a match, the data that corresponds to the data in Column B (text) will average (Column G, number) using a CSA formula, for example: =AVERAGE(IF($B$3:$B$106=A$110,$G$3:$G$106)) Now the formula above works well, only I have to update the spreadsheet, so when I add new rows the $B$3:$B$106 and $G$3:$G$106 portions are useless. Trying to use the INDIRECT function that many people successfully use in this forum, produces a #VALUE error, =AVERAGE(IF(INDIRECT("$B$3:B"&ROW()-4)=A$111,(INDIRECT("$G$3:G"&ROW()-4))))
View Replies!
View Related
Sumif Formula Needs To Split 2 Criterias Of Addition
you guys very kindly helped me with a spreadsheet a couple of months ago, but i now need to adapt it for another dept. I have completed as much as I can. I need column C and E in the 'totals tab' to only calculate contract and upgrade sales respectively (found in 'service orders' tab). I also need Scott's and ash's individual sales to be calculated in corrisponding tabs. Most of the formulas are in place so just need them tweaked slightley.
View Replies!
View Related
Basic Addition, Subtraction & Multiplication
Take a single cell in column D, and multiply it by a single cell in column E, which will equal F. Take column F, and multiply it by .02 (2%), which will equal G. Take a cell in column G, and subtract it from F, which will equal I. And this all takes place in the same row. Then have it move down to the next row, and do the same thing..... so it would basically look like this..... A B C D E F G H I 1 D1 E1 (D1*E1) (F1*.02) (G1-F1) 2 D2 E2 (D2*E2) (F2*.02) (G2-F2) 3 D3 E3 (D3*E3) (F3*.02) (G3-F3) For easier reading.... in each row I want it to do the following math D*E=F F*.02=G G-F=I And then do it for every row that I have data in (excluding the VERY first row). I am -COMPLETELY- sorry if I broke any rules, and am also sorry for the poor representation
View Replies!
View Related
Add Addition If Condition To Existing Formula: Long Formula
This task joins a string together based on a number of characters per cell in the range. I want to isolate one range, Col N, and add an IF condition to it. There may be other issues preventing this from happening, e.g. the number of IF that exist in the complete formula. I will isolate the current cell and its requirements and then post the entire formula at the end for reference....
View Replies!
View Related
'Remote' Addition
I am hoping someone with excel experience can be of help to me with an unusual request for excel. Assume cell A1 = 2, B1 = 3 and i wish the sum of this (5) to appear in cell C1. Very straight forward so far, however i wish the result to appear in C1 when i left click on a cell other than C1, say for example D7. I can't use any macros for this.
View Replies!
View Related
Pivot Table Retains Old Source Data In Addition To New Source Data
I have a report that was created for 2005 that contains two worksheets: a "source data" worksheet and a " pivot table" worksheet. I cleared out the 2005 data in the "source data" worksheet and replaced it with 2006 data...after this I refreshed the Pivot Table and everything seemed fine. When looking at the file size I noticed that it was almost twice its original size....upon further investigation I found that the Pivot Table was internally holding onto the old source data (the "Show" functionality of the rows/columns in the table lists the 2005 row/column headers as well as the 2006 headers....even though no data from 2005 is shown in the Pivot Table). Does anyone know how to purge the old data from the internal Pivot Table memory? I hope this is enough information....let me know if you need more. Thanks in advance for any help, Jon
View Replies!
View Related
IF Calculation
Hoping someone might be able to kindly help me out with this one. It's for a spreadsheet of call charges (credit crunch thing). On the sheet, I have the call charge up to an hour ($H$5). Over an hour, it's charged per minute at the rate in $H$6. In cell E27 I can enter the number of minutes for the call. So basically, if E27 is up to a value of 60 then the cost is just H5, if the value in E27 is 61 or more then it's H5 + (E27-60)*H6. I'm thinking it's an 'IF' but keep making a mess of it...
View Replies!
View Related
Calculation On Time
I have been burning brain cells trying to figure this out. I get these numbers from an online source and they come in like this: A B C D E 1/1/0912:01AM02:40AM11:18AM07:55PM The times do not come in as times...when I format the cell to time it doesnt change...that is my first problem. What I would need to do to these times is: take B and C and find what time is in the middle of them and put that in a different column. This mess will also need to be plotted on a chart with time by the minute for one day as the X axis. In my example I drew lines on the chart to show what I mean....the blue lines I dont want charted...I use those to find the time in the middle.
View Replies!
View Related
Linest Calculation
I'm trying to implement the linest formula in a programming language for my coursework. I've looked on excel help but it only explains on how the function selects data. how to the values are calculated and the steps?
View Replies!
View Related
Date Calculation
I have a start date, generated onto cell B4 from a user form datepicker control. I also have a course type in cell C4 that course has a constant number of days. I would like to add the number of days of the course to the start date to give me an end date in another column.
View Replies!
View Related
Auto Calculation
i have a workbook with about ten sheets. These ten sheets have an estimated 500+ formulas each - the feed (calculate) from data on two data sheets. I now have a total of twelve related sheets that work together. I also have one additional sheet for various work named MiscWork - this sheet is NOT affiliated with the other twelve sheets. my issue is whenever data is added, calculated, or even moved, excel recalculates ALL formulas; even on the unaffiliated twelve sheets. how do i force excel to only calculate the formulas and related data that has changed?
View Replies!
View Related
Time Calculation ...
Having been looking round this site for quite some time now and always finding what I needed I am now a registered member who needs your expertise. I have a spreadsheet for which I need to calculate hours worked depending on a few criteria. [data] ... The criteria is that Sat/Eve is 8pm to 6am weekdays and midnight to midnight on a saturday. Sun is midnight to midnight on a sunday, BH is a bank holiday and basic is everthing else. What I want to know is it these columns can be populated automatically using formulas. I would really appreciate it if someone out there is up to completing this challange, as I have to manually populate this at the moment and it can be 5000+ lines long (it takes hours). If i need to change the layout it's not a problem, whatever it takes to automate it has got to be worth the effort.
View Replies!
View Related
Availability Calculation
Has anyone got a spreadsheet that will calculate the availability of a server based on its hrs of service. Currently my spreadsheet will give me the availability of a server who's service hours are 24/7 however I have servers that are only supported 5 days a week between 07:30 and 18:30 and so only want to calculate failures that occur during that time when it comes to Availability. I would of thought there would be a program on the market that does this but I haven't come across it and our company are kean on ITIL. So to summarise, I key in downtimes every day what ever time of day they are but I want calculations on availability to only take in to account failures between 07:30 and 18:30 on certain servers.
View Replies!
View Related
Slow Calculation
I got a work sheet with 672 columns of information that im trying to cross compare against. I wanna compare each column against every other column in that row. I have 200 rows of data. That means each i need excel to do 226,128 comparion calculations each row. So that means in the entire work sheet its gotta do 91 million comparisons. Im on a dual core 1.8ghz core 2 duo cpu and 2 gigs of ram on xp pro with excel 2007. I even bumped up my virtual memory by 3 times the size it was yet still its taking forever. Its taking over 3 hours to do this whole page of calculations. So i opened up visual c++ and quickly programmed in the same code with some generic values and within 3 seconds it computed it all. My guess is that the bottle neck is when excel has retrieve data from the cells because other than that i cant figure out why its so slow. Heres a section of my
View Replies!
View Related
No Of Months Calculation
in calculating the no of months in below scenario. Fiscal year 2009 comprise of Jan 2009 to Dec 2009 Fiscal year 2010 comprise of Jan 2010 to Dec 2010 Fiscal year 2011 comprise of Jan 2011 to Dec 2011. For example I have a period starting from Sep 2009 to Feb 2011 I need formula for the calculation of number of months in each fiscal year. In above example number of months in Fiscal year 2009 will be 4, in 2010 it should be 12 and in 2011 it should be 2 months. Structure of file Starting period is mentioned in column A and Ending period is mentioned in column B. Fiscal year 2009 in column C, 2010 in Column D and 2011 in column F.
View Replies!
View Related
Same Time Calculation
I am trying to get a total column that will give the total only when two particular devices are down at the same time. This total will be taken from a long list of downtime entries for different devices but I only want the total when two particular devices are down, for example Devicedatedowntimedateuptimetotal time 102/01/0911:00:0002/01/0911:09:0000:09:00 202/01/0911:00:0002/01/0911:04:0000:04:00 202/01/0902/01/09 103/01/0903/01/09 303/01/0903/01/09 604/01/0904/01/09 204/01/0913:09:0004/01/0913:12:0000:03:00 104/01/0913:02:0004/01/0913:15:0000:13:00 505/02/0905/02/09 total 1/200:07:00 In the example I am just wanting to work out the total time when both device 1 and 2 were down at the same time, above the total would be 7 minutes because for 4 minutes on the 2/1/9 and 3 minutes on the 4/1/9 they were down at the same time.
View Replies!
View Related
Calculation Between Two Dates
I need to find out the amount of time between two dates for filling out funeral benefits. The form asks how long the person has been alive in Years Months and Days. I would like to know if I put for instance 10/21/1955 in say A1 as the birth date and 01/25/2006 in B1 as the date of death. So what is the formula, if one, to calculate the time in years months and days that has passed between the two dates?
View Replies!
View Related
Calculation According To Date
I have a data in excel , sample sheet attached. and i have another place for compile where all the data is summarized What i want is If the agent name is example 1 and his mistake is present in raw data and it matches the agent id , date and financial then i want excel to calculate how many " financial " error agent made on that particular date only so that i can assign to another agents too , to get exact data no matter in whichever series that data is inserted in excel. if i use countif and if all the condition are met it shows me all financial mistakes count and if it shows false it turns to zero . if agent make " financial mistake " on 1st nov and he made another non financial mistake then as it should show only the count of that particular agent " financial mistake " on that date only from the given RANGE DATA
View Replies!
View Related
Use IF And ROUND In Same Calculation
I'm creating a spreadsheet to calculate materials with the following columns Cost/10% of Cost/Customer Cost/Qty/Total cost. I understand that whilst showing rounded to 2 decimal places excel stores more than this in the cell. which then throws out the Total cost by a few pence. My research leads me to believe I need to use the ROUND function but I'm unsure which cell to use it or how.
View Replies!
View Related
Activate The Calculation?
I have a spreadsheet with several formulas where I have to go into each one of them to activate the calculation. I use F2 and enter. Automatic calculation is on. Do any of you know how this can be done automatically. A VBA-code will fit the purpose.
View Replies!
View Related
Calculation Up To A Set Value
I have a series of monthly revenues and want to calculate each month a commission % - but only want this commission calculated up to a defined limit from the previous months and current month and then to stop when the limit is reached.
View Replies!
View Related
Interest Calculation
I have a macro that formats a spreadsheet to show outstanding invoices, grouped and subtotalled by month. To add to this I need VBA code that will use the subtotals to calculate interest on overdue accounts. Interest becomes due a calender month after the month in which the invoice is dated. So for example a January invoice would start to accrue interest on 1st March. Below is the subtotals code (sadly the totals don't adjust if data is added or removed but perhaps that is another question for another day.) Dim LastRow As Long Dim NextMonth As String Dim R As Long Dim Rng As Range Dim SubAmount As Currency Dim ThisMonth As String Dim TotalAmount As Currency Dim Wks As Worksheet Set Wks = Worksheets("Reconciliation") LastRow = Wks.Cells(Rows.Count, "A").End(xlUp).Row Set Rng = Wks.Range(Cells(2, "A"), Cells(LastRow, "D"))
View Replies!
View Related
Avoiding Re-calculation F9
I have a sheet that requires me to press F9 each time I open it to re-calculate all cells. Why do I need to do this on this 1 sheet? A few months back it was fine and didn't require the extra attention.
View Replies!
View Related
Year Calculation...
Is there an in-built function within Excel that will help me ascertain what year is next year, and what year is the year before current? I am using =YEAR(TODAY()) to ascertain what year we are currently in, but cannot figure out how to go one backwards and 1 forwards?
View Replies!
View Related
Single Calculation
Is there a way for me to have a formula perform its calculation one time only... meaning that if the precedent data changes it (the formula) won't compute again, thus leaving the previous number it calculated unchange...
View Replies!
View Related
Calculation Direction....?
My understanding of Excel is that the calculations are performed in Column A first and then down through the rows in Column A. After all the calculations are finished in A, the calculation moves over to Column B and down the rows in B. Is this true? I know that Excel is a little more complicated than that especially when it creates a queue for calculations, etc. However, assuming there's no calculation list/queue, would the above be correct?
View Replies!
View Related
YTD Calculation
How do I calculate YTD from 1 MTD cell? The YTD cell needs to keep a running total of the MTD cell. If the current YTD cell has the number 11 in it and I typed 2 in the MTD cell the YTD cell needs to increase by 2.
View Replies!
View Related
Offset Calculation
I want to change this calculation located in AL13 - = SUM(( OFFSET(INPUT!$A$1,12+AL6,2)+OFFSET(INPUT!$A$1,13+AL6,2))/AL5) to say - If (Offset 0 rows and 3 columns from AL13 = "Gross" then =SUM((OFFSET(INPUT!$A$1,12+AL6,2)+OFFSET(INPUT!$A$1,13+AL6,2))/AL5) otherwise 0)
View Replies!
View Related
|
TRACKER
