Index + Match is probably the fastest:
See Ken's example

Array Sum is probably the shortest:
=SUM((A6=A2:A4)*(A7=B1:F1)*(B2:F4))
Confirm the formula with Ctrl+Shift and Enter.

Unless you use the intersection approach:
See http://www.dicks-blog.com/archives/2...and-intersect/
or Gordon's example.


Ola Sandstrom