Carim,

Not so sure.
Dates are spread across 10 different years, with different dates and
months etc.
WOuld I not need a function to group the financial year first and then
use sumproduct form there? I'm not an expert but after reading
previous posts grouping dates by financial years seems pretty daunting

Thanks
Tony

Tony,

Yes. You are right. My understanding was that you had already 3 columns
:
Beg Date, End Date and Amount ...

Cheers
Carim

Tony,

As far Fiscal Years are concerned, you could adapt
your own UDF based on the following one :

Function FY(dDate As Date) As String

Select Case Month(dDate)

Case 6, 7, 8: FY = "Q1 " & "FY" & Year(dDate) + 1

Case 9, 10, 11: FY = "Q2 " & "FY" & Year(dDate) + 1

Case 12: FY = "Q3 " & "FY" & Year(dDate) + 1

Case 1, 2: FY = "Q3 " & "FY" & Year(dDate)

Case 3, 4, 5: FY = "Q4 " & "FY" & Year(dDate)

End Select
End Function

Hope this clarifies

Cheers
Carim