Countifs, date range on multiple sheets

[HuskyJones]

Hi Hive
Can i pick your brilliant minds again!

I have a workbook with multiple sheets (43). Column "M" on all worksheets is a date range that's completed when a customer registers.
On a front page I want to be able to
a) count total for a current month combined all sheets (ColG) - i've tried variations in G10 of.. =COUNTIFS('North Central London:Wales'!M3:M10001,">=01/02/2025",'North Central London:Wales'!M3:M10001,"<=28/02/2025")
b) count for the current month/quarter for each tab individually (ColD) - i think this might be the EOMonth thingy?

Hope i'm making sense, you folks normally understand me

 

[Cubist]

For a), try:

=SUM(--(EOMONTH(+VSTACK('North Central London:Wales'!M3:M10001),0)=DATEVALUE("28/02/2025")))

 

[HuskyJones]

For a), try:

=SUM(--(EOMONTH(+VSTACK('North Central London:Wales'!M3:M10001),0)=DATEVALUE("28/02/2025")))

That's fabulous thank you!!! need to learn more about vstack!

now to try and figure out the current month bit

 

[Cubist]

figure out the current month

Try:

=SUM(--(EOMONTH(+VSTACK('North Central London:Wales'!M3:M10001),0)=EOMONTH(TODAY(),0)))