View Single Post
      01-03-2008, 03:18 PM   #3
Dleo
Brigadier General
Dleo's Avatar
Cyprus
209
Rep
3,358
Posts

Drives: 2010 X5
Join Date: Jul 2006
Location: NYC

iTrader: (2)

Quote:
Originally Posted by jumpingjz View Post
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
__________________
Appreciate 0