I want to make a personel sales sheet that will allow me to track my
commissions. I make a list for a entire month and start each line with
the date. What I want to do is to be able to call up all the sales for
each day to track sales. What I am needing is to be able find all sales
stats by day. Can some one tell me the look up formula to be able to
isolate mutible sales in one day by the date. here is an example

10/1/05 John doe 1 0 0 1 2
10/1/05 Jane doe 1 1 0 2 0
10/2/05 Rob doe 1 2 2 0 1

the numbers are how many items are sold for each item. I want to be
able to add only the 10/1/05 sales for example. If you have know the
formula and have time to answer please let me know. you post it here or
email me at

Thank you in advance.