Thanks Siva for solving this.

Just want to clarify, the "*" in the formula denotes "and" - am i right? I.e. :

Sumproduct((data1=cell1)*(data2=cell2) ...
Sumproduct((compare data in table 1 with data in cell 1) "and" (compare data in table 2 with data in cell 2) ...