sumifs function returning 0 error...

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!

Are there leading/trailing spaces in the region/sub-region?

No, not that I can see. the data is in a table format.

I did this test for each criteria by themselves with the budget range and the only criteria that didn't equal to 0 was this section, for the region:
AnnualBudget! A10:A236, sheet2!B2

This actually showed the actual budget value, so it displays the total amt with both true and false for recurring. however, when I try to add the recurring is true criteria, it goes back to 0 again.

Try This

=SUMIFS(AnnualBudget!E10:E236,AnnualBudget! B10:B236, TRUE, AnnualBudget! A10:A236, sheet2!B2, AnnualBudget! D10:D236, sheet2!B3)