View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MB MB is offline
external usenet poster
 
Posts: 53
Default 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 !!???!