Thanks..

I managed to get it to work with :-

{=SUM(('Budget Data'!$A$3:$A$806=$B$5)*('Budget
Data'!$B$3:$B$806=VALUE($A28))*OFFSET('Budget Data'!$D$3:$D$806,0,'Criteria
Sheet'!$E$7-1))}

"Toppers" wrote:

If I understand correctly, this worked OK for me:

G1= date (for month) e.g 01/02/07 for February (UK date)

Monthly data starts in Column D i.e January,E=February etc

=SUMPRODUCT(--('Budget Data'!$A$4:$A$801=$B$3),--('Budget
Data'!$B$4:$B$801=VALUE($A28)),(OFFSET('Budget
Data'!$D$4,0,MONTH(G1)-1,798,1)))



"MB" wrote:

Still no luck with this one chaps! They all look promising, any more ideas?


"MB" wrote:

I have used the following formula successfuly to solve a multiple criteria
problem.

{=SUM(('Budget Data'!$A$4:$A$801=$B$5)*('Budget
Data'!$B$4:$B$801=VALUE($A28))*'Budget Data'!$D$4:$D$801)}

However I need to bring in some sort of INDEX/MATCHING solution. At the end
of the above where it says $D$4:$D$801.....I need it to look for the correct
column rather than just look at "D" as depending on the month, the result
should be coming from any of columns 1 to 12. This is obviously difficult
with a multiple criteria array formula!

HELP!!!!!