Karthik,
Doesn't the alternative array-entered expression given in my earlier
response:
=SUM(IF(ISNUMBER(H$2:H$9999),IF((A$2:A$9999=L$5)*( B$2:B$9999=L$6)*(C$2:C$9999=K8),H$2:H$9999)))
do the job for you, as-is ? I tested it fine here, it evaluates correctly in
the face of possible #DIV/0! errors in col H. And it should work for you just
as well.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---