Multiple Criteria and Multiple Columns

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 !!???!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Criteria, Multiple Column 9
SUMIF with multiple columns in sum range 5
Summing cells based on mulitiple criteria over mulitple columns 1
AVERAGEIFS Multiple Criteria: use an Array? 7
Excel Subtracting multiple columns from another column 3
Distinct Counts with Multiple Criteria 1
Sum a range based on a column 2
SumIF based on Multiple Conditions 7

Top