thanx a lot ...it working..

---------- Post added at 11:39 PM ---------- Previous post was at 11:37 PM ----------

Quote Originally Posted by CheshireCat View Post
Try this:

=SUMPRODUCT(--($A$2:$A$14=$G2),--($C$2:$C$14=H$1),$B$2:$B$14)
Thanx a lot ..it's working..