Sum a range based on how many rows in a QUARTER(date Based)

I have a table that has around 3000 rows that goes back around 3 years.

I'm trying to sum data in the in column D based on the date in column H

The formula below works for Suming the based on what month and year that is selected in Cells 'Dashboard Workings'!B2 and 'Dashboard Workings'!B1 ('Dashboard Workings'!B2 = 1 & 'Dashboard Workings'!B1 = 2012

Please Login or Register  to view this content.

So this finds 21 instances in the table in January this year and then sums Table3[Outage Length (minutes)] to get a figure around 3000

I thought i could use the formula below the find the quarter but get an error message, i think it should work but are missing parentheses

Please Login or Register  to view this content.

How this makes since

delboy2405,

Assuming that in 'Dashboard Workings'!B2 is the quarter number (1, 2, 3, or 4), you should be able to use this:

Please Login or Register  to view this content.