Thread: excel formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelley Shelley is offline
external usenet poster
 
Posts: 9
Default excel formula

store 001 004 005 006

item1 50 42 32 74
item2 45 36 22 98

above is similar how my spreadsheet is set up, but with several locations
and several item #s. I have an inventory of each item, say 50 that I need to
add to each of the numbers above for item1. I tried to just create a new row
and add 50 to each but it would not stay on the cell I had 50 in when I
copied over.

"Jacob Skaria" wrote:

It would be clear if you can post an example.

--
Jacob


"Shelley" wrote:

I have rows of inventory numbers and I need to add a single number to the
number already in the cell, make sence? I am adding additional inventory to
the number in the cell and I don't want to have to add the numbers.