Add Number to Multiple Cells in Excel

If you’ve already entered a number in a cell, or a group of cells, what’s a quick way to add something to that amount?

For example, I keep track of my To Do list in a workbook, and one of my items is “Daily Admin tasks”. Sometimes, I start the day by answering client emails, posting links to my latest blog post, and doing the accounting for the previous day’s sales.

So, I enter the time spent – 0.75 hours – and move on to the next task.

addamount05

Later in the day, I might spend another 45 minutes on Admin tasks, so I want to add that to the previous amount, in cell D5.

If it’s late in the day, it might be difficult to add 0.75 + 0.75 in my head (or early in the day, if I haven’t had my coffee yet!)

Use Paste Special

One way to do this, and avoid basic mistakes in arithmetic, is to use Paste Special – Add.

  • Type the number in a cell, and copy that cell.
  • Then, use Paste Special – Add, to paste that amount into another cell.

addamount06

That technique works well, but it takes a few steps – and that adds more time to my Admin tasks!

Use a Macro to Add Amounts

To make the job easier, I created a couple of macros that add numbers to selected cells. There is a link to the download page, at the end of this article.

  • Macro 1 adds a set number to the selected cells.
  • Macro 2 asks you to enter a number, then adds that number to the selected cells.

In the macro code, I use 7 as the set number, and the default number, because I have several weekly tasks. Once they’re completed, I add 7 to the date, to move them to next week’s schedule.

You could change the code, so the set/default number is something that you use frequently.

addamount04

Video: Add Numbers to Multiple Cells in Excel

Watch this video to see how to use the Paste Special command, and see how to modify the macro code, to change the numbers.

Or watch on YouTube: Add Number to Multiple Cells in Excel

Download the Sample File

To see how the macros work, and get the code to use in your own files, you can visit my Contextures website. You’ll find the instructions and sample file on the Add Number to Multiple Cells page.

The zipped file is in xlsm format, and contains macros. Enable macros when you open the file, if you want to test the code.

____________________

You may also like...

2 Responses

  1. VIJAY KUMAR says:

    thank u, easily i have solve my quire through you video.

  2. John says:

    Hi

    Can you help me to define formula for Excel?

    ex. my cell has 10 8 9 7 3 5 6 9 4 condition x

    I need formula to add how many number from the left based on condition.
    if condition is 3 then add 10+8+0
    if condition is 5 then add 10+8+9+7+3 etc

    Thank you for help

Leave a Reply

Your email address will not be published. Required fields are marked *