excel formula

  • Thread starter Thread starter Shelley
  • Start date Start date
S

Shelley

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.
 
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.
 
Back
Top