Adding empty cells

[caesarius]

Hello community,

I want to create a inventory list for my home office.

Now i have a (probably easy) problem when adding cells.

I want to add the inventory taking (A1) and the incomming goods (A2) to the actual stock (A3).

Set phrase for A3 is =(A1+A2), which works, but when I delete the content of A2 excel thinks its zero and just shows A1 in A3.

How can I tell excel to sustain the content of A2 in A3 when I delete the content of A2??

Please help, this easy task will revolutionize my inventory taking

Best regards from Berlin,

caesarius

[MarvinP]

Hi caesarian and welcome to the forum,

I suggest you use a List or Table structure for your data. Excel loves data that is in rows and columns. I'd suggest you use a single row for each item in your home inventory. See the link for more info on Excel Tables. They are called Lists in 2003 version of excel.
http://office.microsoft.com/en-us/ex...010048546.aspx