# Needing =DSUM to use 2 sets of criteria

#### Roller

##### Board Regular
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?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Roller

##### Board Regular
I think I found a solution... I just have to list the period next to the named range in which I identify all the Company #'s to a specific customer.

Replies
6
Views
1K
Replies
3
Views
237
Replies
3
Views
6K
Replies
7
Views
395
Replies
2
Views
418

1,191,204
Messages
5,985,262
Members
439,953
Latest member
suchitha

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back