addition

Hi, in my spreadsheet I am subtracting a lesser datetime from a greater datetime in order to get an elapsed time (E7-E5) across several columns. These values (example: 07:20/2017 15:57 - 07:20/2017 10:49 = value 0.213888889) are then added (=sum(E10+F10+J10 etc), the result in this case is 0.22...

Hi All, I have the following problem... I have many numbers in the following format associated with several costs: A B C 06.01.01.01.01 £8000 £40000 06.01.01.01.02 £2000 £50000 06.01.01.02.01 £9000 £60000...

Have a table as below <tbody> Date Sample A Sample B 01 Mar 1 2 02 Mar 5 6 04 Mar 10 20 10 Mar 1 1 11 Feb 1 1 </tbody> When Date column has date < current date -7 days, need to Add Sample A and Sample B So the output will be 2 (for the 11 feb column)

I am not sure if this is possible, I have done a bit of Googling but cannot see an answer for this specific problem. I have an Excel Workbook with Tabs running from April to March for monthly data collection. Each sheet is exactly the same except for the month name. In the sheets I have 5...

Hello, I have excel 2010 and am trying to figure out how I can add x number of days to a specific start date. The calculation is to include weekends, but if the end date falls on a holiday go to the following day. Any help would be greatly appreciated!!! Thanks

Hey so I'm trying to make something in VBA that would make you input current payment and additional monthly, as well as select a range of a column that consists of FX rates. Then enter in the current month and calculate the information up to then and post it in this kind of format. It's going to...

With the code below, I am trying to add two values and then set a cell as that value. Currently this code is putting a 0 in the target cell instead of the two defined values i am trying to add. I have underlined the areas i think are the issue. Any help on why this is not setting the cell to...

I have 39 characters in a cell something like this 101010000614021350229003000000000011.10, when I copy the same in Excel 2007 version it comes out like this 101010000614021000000000000000000000.00 Would someone help me on how to copy it exactly in Excel.

Hi, I'm looking for a formula that would help add the values of cells that a pivot table filter yields. For example: I have a large amount of data and I search for target word "Arginine" in the pivot table. Arginine values would appear in cells F1, F8, F100. Is there a convenient Macro that...

Add Multiple Values Based on Criteria Search for the word "Clear" in the Task column. If the word "Clear" is found, go to Value column. Add all values starting from "Clear" down to the end of the list. If it is larger than 10, return the word "OK". Otherwise "Poor". If 20, return the word...

I am currently attempting to select multiple rows (Rows are variables) to group via a macro. The problem is, it is not selecting the rows i want. It seems to be putting the variables together as opposed to adding the totals together ie, if MSTextBox = 3 and AVTextBox = 4, It groups Rows 4-34...

Hi All I have cells with numbers. for example: <tbody> 2 3 4 5 </tbody> I would like to learn a formula that would add these all but show as below <tbody> 14 </tbody> when I go a click on this cell I want to see the value separately as below: <tbody> =2+3+4+5 </tbody> Any Ideas...

Hi, i have two variables which holds a range x=a1:f16 y=a17:f17 i want to do a addition. i want my output to be z=x+y i.e z=a1:f17 Please help me out... :smile:

Hi, I have about 25 columns and 116 rows all with numbers in them. For each row, i want to add up the z scores for each respective column. I already calculated the average and standard deviation at the bottom of each column. I've tried multiple ways but nothing seems to work. Any help would be...

I have a spreadsheet with exisiting data and wish to add 100 to each number on the sheet. For example the existing data maybe say 250, 300, 110 etc. So that an additon is made to each existing number on the spreadsheet using a formula so that after adding 100 numbers woul dbe 350,400,210 etc...

I need help populating a spreadsheet. I have a large spreadsheet with all the data, and I need to look up this data from within another tab. See below. This is the data: Site--------Vendor---- -Month----Use---Cost SiteA--------Bob---------Jan------1------2...

The idea is the following: Dim VariableRow As String ActiveCell.FormulaR1C1 = "=SUM(RC[-2]:R[VariableRow]C[-2])" I have values in column A but in column B i have nother value that it is going to tell the number of rows the sum is going to cover in column A Can this be done in VBA or just...