# Sumifs using both date range AND text

#### bear1970

##### New Member
Hello, I'm wanting to sum a specific column if it's within a specific year and meet's a specific criteria. For example (please refer to attached pic). I'd like the sum of all Dues & Subscriptions in 2017.

So far I've been able to use the text to come up with an amount using the following formula: =SUMIF(D:D,"*Dues & Subscriptions*",C:C)

But.. when I add the between dates =SUMIF(C:C,D:D,"*Dues & Subscriptions*",A:A,">="&DATE(2017,1,1),A:A,"<="&DATE(2017,12,31))

Excel gives the error: "you've entered too many arguments for this function"

#### Attachments

• Excel.jpg
175.1 KB · Views: 47

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### mrshl9898

##### Well-known Member
Try again with SUMIFS

#### bear1970

##### New Member
mrshl9898... pure genius! I FEEL STUPID! Thank you!

#### bear1970

##### New Member
Using the following formula =SUMIFS(\$C:\$C,\$D:\$D,"*Dues & Subscriptions*",\$A:\$A,">="&DATE(2017,1,1),\$A:\$A,"<="&DATE(2017,12,31))

In this same formula, how can change it to reference one cell for the criteria, Dues & Subscriptions instead of using (\$D:\$D,"*Dues & Subscriptions*",) having the formula still look in column D for all Dues & Subscriptions???? Let's say the cell having the criteria, Dues & Subscriptions is in cell H22

Never Mind.. I got it! =SUMIFS(\$C:\$C,\$D:\$D,H22,\$A:\$A,">="&DATE(2017,1,1),\$A:\$A,"<="&DATE(2017,12,31))

#### mrshl9898

##### Well-known Member
Glad you got there, it's always the little things we overlook

Replies
5
Views
339
Replies
6
Views
483
Replies
0
Views
26
Replies
9
Views
378
Replies
9
Views
201

1,127,321
Messages
5,623,994
Members
416,004
Latest member
reitz1

### 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