Hi

If you use a cell to hold the column letter you wish to take the values
from, I used P1, then

{=SUM(('Budget Data'!$A$4:$A$801=$B$5)*('Budget
Data'!$B$4:$B$801=VALUE($A28))*
INDIRECT('Budget Data'!$P$1&"4:"&'Budget Data'!$P$1&"801"))}


--
Regards

Roger Govier


"MB" wrote in message
...
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!!!!!