Countif formula to count based on the timeframe indicate on cell

Hi,

I have a sum product formula which i have in the attached worksheet in the tab named tally. It counts accurately based on the criteria that are set. However it counts based on only the current month and i would like to consolidate all the monthly worksheets in a single worksheet which can present the tally on toggling the period. I have created a list using data validation in the same worksheet to be able to toggle between months, quarter and the year.

The help that i require is for the formula to count based on the period data that is in cell H1 and count the sum products of the criteria (Columns A:D) in the database tab. I have a created a sample on the worksheet to show some expected results.

Not sure if you want to add to existing formulas, or create a new one for the dates, but this is the conditional criteria you need to put in a SUMPRoduCT

(YEAR(H1)=YEAR(Database!$B$2:$B$1000))*(MONTH(H1)=MONTH(Database!$B$2:$B$1000))

Thank you. This worked.