Question: I have a spreadsheet with roughly 750 part numbers and costs on it. I need to add $2 to each cost (not total the whole column). The range would be something like D1:D628 and I've tried using =SUM but either I'm doing it wrong or it isn't possible. 

I initially tried `=SUM(D1:D628+2)` and got a circular reference warning, I've tried variations of the formula and keep getting errors even after removing the circular reference. I also tried the following VBA module insert:

```
Sub Add2Formula()
' Add 2

For Each c In Selection
c.Activate
ActiveCell.FormulaR1C1 = "= " & ActiveCell.Formula & "+2" 
Next c

End Sub

```

Answer: 
If you just want to add 2 to a range of numbers (not formulas) then 

enter the number 2 in a blank cell somewhere
copy it
Select the cells you want to add 2 to, and then select paste special, choose ADD as the operation option.
The following formula should work

`{=SUM(D1:D628+2)}`

Leave out the curly braces but press `CTRL`+`SHIFT`+`ENTER` to enter the function (rather than just `ENTER`)

EDIT: explanation

by pressing `CTRL`+`SHIFT`+`ENTER` excel treats the formula as an array, and loops through each cell individually adding 2 and then summing