A few points:
1) An "array formula", in Excel, is a special kind of formula that is completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER).
2) In SUMIF and SUMIFS, the arguments are reversed.
SUMIF(Criteria_range,Criteria,Value_range)
SUMIFS(Value_range,Criteria_range,Criteria,Criteria_range,Criteria,etc)
3) Using SUMIF on a large list when you only need one value can be an inefficient use of Excel's processing resources.
4) Referencing an entire column when you don't need to can also be an inefficient use of Excel's processing resources.
5) Try this regular formula in your posted workbook
Does that help?
Bookmarks