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

[delboy2405]

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

=SUMPRODUCT(--(MONTH(Table3[Incident Submit Date])='Dashboard Workings'!B2),--(YEAR(Table3[Incident Submit Date])='Dashboard Workings'!B1), Table3[Outage Length (minutes)])

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

=SUMPRODUCT(--(ROUNDUP(MONTH(Table3[Incident Submit Date])/3,0))='Dashboard Workings'!B3),--(YEAR(Table3[Incident Submit Date])='Dashboard Workings'!B1),Table3[Outage Length (minutes)])

How this makes since