Hello All,
I could use some help trying to get =dsum formula to return the correct results. I have a text file which will be imported into Excel. The basic file has columns being (in order): Geographic Market, Company#, Product, Customer Name, Period, Sales under $7500, Sales over $7500, and Net Sales. Company# is specific to a customer's division (i.e. customer ABC has 3 divisions, east coast=300, midwest=350, and west coast=400). Period is monthly. This file contains a rolling 12 months of data. I can use DSUM to calculate a customer's sales for the rolling 12 months, but I would like to extract each Customer's sales by month. Is this possible?
I could use some help trying to get =dsum formula to return the correct results. I have a text file which will be imported into Excel. The basic file has columns being (in order): Geographic Market, Company#, Product, Customer Name, Period, Sales under $7500, Sales over $7500, and Net Sales. Company# is specific to a customer's division (i.e. customer ABC has 3 divisions, east coast=300, midwest=350, and west coast=400). Period is monthly. This file contains a rolling 12 months of data. I can use DSUM to calculate a customer's sales for the rolling 12 months, but I would like to extract each Customer's sales by month. Is this possible?