I had submitted a previous question but it was getting confusing and I
believe head ing in the worng direction.

Here is the situation.

I have a document with 2 sheets. On the first sheet I have all of the sales
data. 1 line for each item. The second sheet has totals. I am trying to
calculate the sales on each day but I want to exclude the returns.

What I want to say is....Give me the total sales for xx/xx/xxxx(has its own
cell) but exclude returns(start with "600)