=SUMPRODUCT(--($A$10:$A$15=A1),--($B$10:$B$15=B1),$C$10:$C$15)
The first part
$A$10:$A$15=A1
checks all the cells in the column, and when equal returns something
like
False, True, False, False, False
The -- preceding it converts this to
0,1,0,0,0
Same with the second column (B10:B15), The last column has actual
values. The sumproduct simply multiplies each element row-wise and then
adds up. So we have
0,1,0,0,0 * 0,1,0,0,0 * 11,12,13,14,15
=0,12,0,0,0
=12
You can select the cell which holds the formula and click on 'Evaluate
formula' to see how it works.
Mangesh
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=378013