SUMIF/SUMIFS Amounts in Date Range

[buggaboo76]

Hello! I'm struggling with needing a formula that allows me to:

1) Look at the date range in column B,
2) verify for this cell which would be named July above it, that it looks in B1:B1000 for any date in July,
2) verify in column F that "INT" is within the text
3) if so, total the values in column H that match those conditions.

The total for those conditions would be $1359.90.

Ideally I would want to repeat this for the other months of the year as well. So, in essence, summing all expenses for July that are "Int" in column F. Any help would be really appreciated. I hope I was not confusing with this.

Column B

6/17/2019	ORD	7411231	800106	PD Int Labor Act	D	193.68
6/18/2019	ORD	7411231	800106	PD Int Labor Act	D	290.52
7/8/2019	ORD	7411231	800106	PD Int Labor Act	D	28.26
7/9/2019	ORD	7411231	800106	PD Int Labor Act	D	141.30
7/10/2019	ORD	7411231	800106	PD Int Labor Act	D	28.26
7/9/2019	ORD	7411231	800106	PD Int Labor Act	D	96.84
7/10/2019	ORD	7411231	800106	PD Int Labor Act	D	193.68
7/11/2019	ORD	7411231	800106	PD Int Labor Act	D	96.84
7/22/2019	ORD	7411231	800106	Temporary Labor-Norm <tbody> </tbody>	D	182.89
7/1/2019	ORD	7411231	800106	PD Int Labor Act	D	290.52
7/3/2019	ORD	7411231	800106	PD Int Labor Act	D	290.52
7/15/2019	ORD	7411231	800106	PD Int Labor Act	D	193.68

<tbody>
</tbody>

 

[Fluff]

Ok, try
=SUMPRODUCT((MONTH($B$2:$B$335)=7)*(ISNUMBER(SEARCH("int",$F$2:$F$335))),$H$2:$H$335)

Just change the value in red for the month that you want.

 

[buggaboo76]

Perfect! Thank you so much. I really appreciate your help on this!!

 

[buggaboo76]

One question I thought of...what happens if it goes into the next year? Will it, for example take January 2019, and January 2020 and combine them, since it is a "1"?

 

[Fluff]

Yes it will.
To prevent that use
=SUMPRODUCT((YEAR($B$2:$B$335)=2019)*(MONTH($B$2:$B$335)=7)*(ISNUMBER(SEARCH("int",$F$2:$F$335))),$H$2:$H$335)

 

[buggaboo76]

Thank you so much. I really appreciate you!

 

[Fluff]

You're welcome & thanks for the feedback