I changed the end range to
=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summa ry!$B3)*(SVEexp!$C$4:$C$48
4=Summary!$C3),SVEexp!$H$4:$J$484)) and got #Value error. The only change
was the end range where the numbers are.



<Andy wrote in message ...
Hi

You need to make sure that all of the ranges in SUMPRODUCT are the same
size. If you alter one of the ranges, you'll have to alter the others
accordingly.

Hope this helps.
Andy.

"Jerry Kinder" wrote in message
...
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