Sumifs using both date range AND text

bear1970

New Member
Joined
Dec 20, 2013
Messages
14
Office Version
  1. 2016
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"

Thank you for any help you can give!!
 

Attachments

  • Excel.jpg
    Excel.jpg
    175.1 KB · Views: 47

Some videos you may like

Excel Facts

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

bear1970

New Member
Joined
Dec 20, 2013
Messages
14
Office Version
  1. 2016
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))
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top