"excelent" wrote:

TRY
=IF(J175<3,SUMPRODUCT((J2:J175=3)*(F2:G175)))


Formula works great I now have to different formulars which work. I have
been able to delete three colomns of formular on each page, there are 23
pages and each has over 300 lines

Thanks again Joco