If you want to make a Table layout as the one on the right; insert this
formula (also see encl.picture):
=SUMPRODUCT(($I2=$B$6:$B$37)*($J2=$C$6:$C$37)*($K2 =$D$6:$D$37)*(L$1=$E$6:$E$37)*$F$6:$F$37)

HTH
Ola Sandström


+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3489 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378233