Hi,

If ive understood correct try this for monthly balance
=SUMPRODUCT((MONTH(C2:C1000)=1)*(YEAR(C2:C1000)=20 08)*(F2:F1000))
and for yearly
=SUMPRODUCT((YEAR(C2:C1000)=2008)*(F2:F1000))

In both cases i've included the month and year in the formula but thay could
be cell references
Mike

"Joco" wrote:

Hi
Is anybody able to help me with the way to create a formular, originally
posted on the 17-04-08, this post contains the full details of my question

Thanks Joco (London)