When I use the "SUMPRODUCT" statement, it multiplies the results. I'm just trying to get them to add. I also tried to use just a "SUM" statement similar to your answer instead of the "SUMPRODUCT" statement, but it didn't evaluate the sum of values in the M column based on the J5:J337<M5:M337 criteria.