Hello hello,

A lowly summer intern, here. I am trying to do a sumifs formula and referencing the IFs that are chosen from a drop box data validation method. I keep getting 0 as the result of my function which I've listed here:

=SUMIFS('Master Staffing'!G6:G500,'Master Staffing'!E6:E500,"Operations Management",'Master Staffing'!F6:F500,"Air Ops",'Master Staffing'!C6:C500,"FTE")

where the words in quotations each represent one of six choices in the drop down box in those cell ranges that feed into the chart I need to summarize the validated master staffing schedule. Is my issue a need for a concatenate that I didn't place right when I attempted it? I think I could work through most of of the other requirements I need to include in my formula if I could get this core down.


All help is very much appreciated!