Multiple Criteria and Multiple Columns
 

Ive got the following array formula to successfully use 2 criteria for the
equivalent of a sumif :-

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

However ,I need the result to not just come from column D. It could come
from any of 12 columns depending on which month I am using.

How can I get the array to look at different columns based on a criteria of
a specific month?

HELP PLEASE !!???!

Multiple Criteria and Multiple Columns
 

See reply to your previous posting: a little patience to get a response
before re-posting!?

"MB" wrote:

Ive got the following array formula to successfully use 2 criteria for the
equivalent of a sumif :-

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

However ,I need the result to not just come from column D. It could come
from any of 12 columns depending on which month I am using.

How can I get the array to look at different columns based on a criteria of
a specific month?

HELP PLEASE !!???!