Hello!
I am try to sync the user's selection to the data I have on a sheet named AnnualBudget to sheet 2 in a workbook (in excel 2010). I have three criterias to meet and sumifs function seems like a good function match. Below is my funtion and it seems all is in order. However, it returns 0 instead the of actual annual budget value. Am I missing something or is the function wrong?
Function:
=SUMIFS(AnnualBudget!E10:E236,AnnualBudget! B10:B236, "True", AnnualBudget! A10:A236, sheet2!B2, AnnualBudget! D10:D236, sheet2!B3)
Explanation of function:
AnnualBudget!E10:E236, the annual budget range to show/sum in the cell where there formula is placed
AnnualBudget! B10:B236, the range of 1st criteria to meet, whether it is true or false
"True", the criteria to match
AnnualBudget! A10:A236, the range criteria of the region for the annual budget
sheet2!B2, criteria 2: the user’s selection of the desired region
AnnualBudget! D10:D236, the range criteria of the sub region for the annual budget
sheet2!B3, criteria 3: the user’s selection of the desired sub region
Thanks in advance!
Bookmarks