Quote:
Originally Posted by jumpingjz
if it's in excel what you can do is
1. create a search key custname_brand_month
2. create the same search key at sales spreadsheet
3. use sumif fomula to sum up sales.
hope that helps.
JZ
|
Thanks for the input, i will try messing with it, the problem is my experience with excel is limited to entering, formating, and organizing data