thanks a lot for responding however, I am attempting to upload the excel sheet to demonstrate the issue better. The filter is a row 12 so, the sorted values never go above 12. Also, the last row with any data in is is 738 so there is no way the data is outside the range. please see the attached file.

Attached Files

sumif but has tobe sorted.xlsx (55.0 KB, 11 views)