Can't be done with an Excel formula...
A cell cannot contain both a formula and a
constant value.
Re: Can't be done with an Excel formula...
***** Not really sure what you are asking for here as your example was actually two colums, but: =5+B1
Re: Can't be done with an Excel formula...
:Oops. Example was supposed to be rows but doesn't really matter. I have put in the answer you gave, but it doesn't work when I want to drag the formula across the row. In the answer you gave, the "5" remains the same for each cell and the B1 changes accordingly. I need the number in the primary cell to remain unchanged but add the additional row to it. Sounds like it can't be done?
***** Not really sure what you are asking for here as your example was actually two colums, but: =5+B1
Hi
It can't be done with a formula, but you can copy your second row and then "paste special" and checkmark "ADD". This will add the values from the second row to the values in the first row
Tommy
You need to get into VBA to work this one Debbie. It is simple enough in there, but I am not sure if you want to get to that level. There is no other way.
THANK YOU! That is exactly what I was looking for. You have saved my wrist from falling off based on the old way I was doing it!!!! Hi