Sumifs Formula with Wildcard Issues

[Yankeesguy1990]

Hi everyone,

I am stuck on a sumifs formula that is pulling data based a date range. I am trying to add another criteria at the end but get a value error when I do. I want to sum the values between two date ranges and if column A starting at row 13 says "Actuals". Any insight would be greatly appreciated!

Below are the two formulas with screenshots showing when it works and when it doesn't.

This formula works: =SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5)

But this one doesnt: =SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,A13:A26,A7)

Below is a screenshot from Excel.

 

[awoohaw]

Well, your criteria ranges must be the same size.. so
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,A13:A26,A7)
should at least be:
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,A13:A945,A7)

But, the word actuals is not even in that range. If you want to just start and grab all the data below Row13
then maybe something like:
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,Row(A13:A945),">=13") But that would be the same as not having that criteria at all.

 

[Yankeesguy1990]

Well, your criteria ranges must be the same size.. so
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,A13:A26,A7)
should at least be:
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,A13:A945,A7)

But, the word actuals is not even in that range. If you want to just start and grab all the data below Row13
then maybe something like:
=SUMIFS(D13:D945,C13:C945,">="&B4,C13:C945,"<="&B5,Row(A13:A945),">=13") But that would be the same as not having that criteria at all.

ah I didnt realize it needed to be the same size but makes sense. I was able to get it to work based on that. Thanks!