COUNT Dynamic Array based on Date to return Dynamic Array Spill Range

Hello Excel Gurus,

As per screenshot,

I have a user input where I'd like to count the [Type] within that quarter.

The quarters are dynamic array spill range returns (G7:P7), where it returns the number of quarters (input on cell H1), based from the starting point (another input on cell F7).

And I need to keep it this way, where the spill range from G7 onwards (across the columns) based on the input on cell H1 and F7.

Given that I have the quarters spilled, now I need to get the counts based on [Type] (user input cell H3:I3) in that quarter.

i.e. Sep 2022, is the quarter for the date Jul 1, 2022 to Sep 30, 2022. And based on [Type] = A or C, we only have 2 dates that lies in that quarter (highlight in yellow).

May I know how do I get the spill range count of it.

Currently, this is the formula that I have, which isn't working.

Please Login or Register  to view this content.

COUNT Dynamic Array based on Date Range as in Quarters.png

Please try

=COUNTIFS(tblDummy[Date],"<="&G7#,tblDummy[Date],">"&EOMONTH(+G7#,-3))

Try

=MMULT(COLUMN(H3:I3)^0,COUNTIFS(tblDummy[Date],"<="&G7#,tblDummy[Date],">"&EOMONTH(+G7#,-3),tblDummy[Type],TRANSPOSE(H3:I3)))

or
=COUNTIFS(tblDummy[Date],"<="&G7#,tblDummy[Date],">"&EOMONTH(+G7#,-3),tblDummy[Type],H3)
+COUNTIFS(tblDummy[Date],"<="&G7#,tblDummy[Date],">"&EOMONTH(+G7#,-3),tblDummy[Type],I3)