I wouldn't categorize the Sumif as clumsy, if it returns the results you desire it is probably the right choice for you. That is, unless it seems to be taking an extrodinary time to calculate. If this is the case other methods could be explored, but for now the Sumif seems appropriate.

A cleaner method though might be a pivot table.