The best replacement for sumifs is sumif.

The best alternatives to sumifs are rated as following:
★★★★★  sumif
★★★★★  sumproduct
★★★  criteria
★★  condition excel
★★  dsum
★  array formula
★  excel
  getpivotdata
  countifs

Your alternative for sumifs is not listed? Suggest!
Speaking about sumifs, one probably shouldn't forget about or.

Other search terms related to sumifs and their ratings are:
★★★★★ or
★★★★ date range
★★ greater than
★ or function
or statement
offset
You have in mind a companion for sumifs and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of sumifs in all years. Click on graph for more.
sumifs
sumif
sumproduct