Any one an expert on excel?

[PaulaSB12]

I have a spreadsheet that I am using at work which has one last bug. Here it is. The spreadsheet takes the waste figures per line and adds them up, but two of the lines have a subsiderary line which takes some of waste. So I have a column for e line catering figure and a column for t line catering line it looks like this




catering line e=1 t=2

e line drop gate
e line run off belt
e line catering
t line drop gate
t line run off belt
t line catering

the catering line taking feed from e or t never both. What i need is if the first row is 1 then the total catering line figure needs to be the e line catering number but if the top line is 2 then the catering line needs to be taken from the t line catering figure anyone know how to do this? Sort of an and or logic problem so
if catering line=1 total catering figure=e line catering
if catering=2 total catering figure=t line catering
if there is no number in the catering line cell total catering figure=0

 

[jbschickens]

The way you've worded this seems a bit confusing to me, but what I think you are trying to do is import a value from one cell/column/row into another cell for calculations. Is that correct? Is there any way you can upload a picture or better clarify what you are trying to do? If it is what I think it is, I can help.