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)))

 

[HuskyJones]

Try:

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

sorry for the long delays in replies Cubist, only work a couple of days a week
That works fab THANK YOU!!
Can I apply the same principle to count numbers before and after specific dates (i.e. 08/11/2024)
Is there a way of working current quarters?
sorry to be a PITA!

 

[Cubist]

Can I apply the same principle to count numbers before and after specific dates (i.e. 08/11/2024)

Adjust the conditions as needed. For example, before 8/11/2024:

=SUM(--(VSTACK('North Central London:Wales'!M3:M10001)<DATEVALUE("8/11/2024"),0)))