I have this formula in use and it works perfectly. I now need to change the
sum area from H4:h484 to H4:J484 and now it only give me 0. How do I get it
to sum the larger area??

=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summa ry!$B3)*(SVEexp!$C$4:$C$48
4=Summary!$C3),SVEexp!$H$4:$H$484))

Thank you, Jerry