Sumifs using both date range AND text

[bear1970]

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

 

[mrshl9898]

Try again with SUMIFS

 

[bear1970]

mrshl9898... pure genius! I FEEL STUPID! Thank you!

 

[bear1970]

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]

Glad you got there, it's always the little things we overlook