addition in excel

  1. jltjr75

    Grab the last values

    I want the final total between both accounts added when I update the numbers quarterly. For example D9+I9 = B1 Where I will have the problem is when I add the next quarter to row 10 (then row 11,12,13...) Is there a formula that can grab the last values (D10+I10) and = it in B1? I would like...
  2. H

    Troubles with addition using macros

    Hello. I'm currently working on a file as a way to learn excel and brush up on some skills. However I have gotten to a point where I need help. I have two sheets I am working with. Sheet1 has two buttons. One is "Win" and the other is "Loss". When selecting the "Win" button, I am wanting to...
  3. J

    Formula for increasing dates by a value requied

    I need help with a formula that will take a date in a cell and add for example 3 days to the date and display the answer in date format. For example: Cell B1 has a date of (01/05/11) In Cell A2 have 3. I want to display in cell B2 the date (04/05/11) sum of B1 plus 3 days hence. If...
  4. A

    Adding row updates linked sheets

    I have a workbook with different spreadsheets. The Base Sheet has all the information and other spreadsheets within the workbook are linked to the Base Sheet. I need to have a VBA code that allows me to add a new row by running a macro. And also when I add data to the newly added row, it...
  5. G

    Add in excel

    Hi all, i think it would be stupid to ask this question here but i am really not able to get this simple formula lets a1,a2,a3,a4,a5,a6 and a7 cells have value 10,12,14,16,18,20,22 and b1,c1,d1,e1,f1,g1, and hi cells have value 2,4,6,8,10,12,14 respectivley i want to add a1 and b1,a2...

Watch MrExcel Video

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.
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.
Go back
Top