I have 8 years of inventory sales data and i want to have this date in a list and have specific information calculated ie how many sold in that year, in that model, that color, that manufacture ect. i have been searching for a week and so far everything i have tried won't work. "=sum((market="usa")*(Customer="Excel")) seems like the type of function i am looking for but when i enter this example i get an invalid name error. Any help or suggestions would be appreciated. There are 8700 rows and 11 columns. I need to calculate about 6 of those columns into date using what i believe to be a sum function.