Multiple Criteria and Multiple Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !!???!
 
See reply to your previous posting: a little patience to get a response
before re-posting!?
 
Back
Top