SUMIFS and Multiple Criteria if Blank

[JMcAnarney]

I am doing SUMIFS by Criteria by Fund, Department, Division. How can I get a formula to only include what I specifically want? For example, if I only want the fund 621 it will add everything up with thAt criteria, but if I type in department code it will narrow the fund down to that 5 digit level and the same for the division code.

I have it set up like a scenerio analysis where in the highlighted items that is what the formula looks up. My data is as followed:

I could do one IF statement but that would not narrow down far enough to division.

 

[jasonb75]

You should be able to do something on the basis of

=SUMIFS(sum_range, fund_range,IF(B2="","<>0",B2))

Using a similar IF(cell="" method for each criteria, use "<>0" for numeric criteria, or "?*" for text.