SUMPRODUCT for information of MONTH and TEXT (2 criteria)

I didnt realize the formula is date sensitive and simply used 31 as the last date of all months.

My cell reference formula is not date sensitive and uses the end of month function to ensure it has the correct beginning and ending dates no matter what month or year it is, including leap years.

With the hard coded date formula it is up to the user to enter the correct beginning and ending dates for the month and year in question.

See post #6, by not acknowledging it, you may end up on some ignore lists, including mine.