SUMIFS with Multiple Criteria and OR Logic

To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant.

=SUM(SUMIFS(sum_range,criteria_range,{"Thona","Thyda"}))

SUMIFS with multiple criteria and OR logic, Multiple Criteria, SUM with Multiple Criteria, Multi Criteria, Advanced Excel, Excel 2007, Excel 2010,