Hi all,

After some good advice on here I'm using the SUMPRODUCT function to
analyse personal expenditure data. It's scanning data on another
worksheet to see if each row of that worksheet falls within the date
range for the column and the catagory for the row. If it does the
value gets added in. I've got a fairly lengthy formula with 3D
references.

=SUMPRODUCT((0+('Money data'!$B$1:$B$3202<DATE(YEAR(J$4), MONTH(J
$4)+1,1))),(0+(('Money data'!$B$1:$B$3202=DATE(YEAR(J$4)-1,MONTH(J
$4)+1,1)))),(0+(('Money data'!$G$1:$G$3202=$A6))),('Money data'!$F$1:$F
$3202))

It isn't quite producing the figures I would expect. What I want to be
able to do is to see what cells on the other worksheet ("Money data")
are going into the sum. Is there a way to do this?

Cheers!

Martin