Attached is the Excel document that I need help with. I would like the sum of all numbers in columns I, J, K, and L to be displayed in the cells that I have labeled for their totals. I need each column to add from row 2 through row 1500 (ex. Cell N2 would contain the function =SUMI2:I1500). When I try to use that function it gives me an error. I believe it is because it's trying to add the formulas that I have entered in the boxes that do not contain numbers. However, I need it to add all the way through row 1500 because more orders will be added to this sheet. Does anyone know a way to add the numbers in row 2 through 15 for columns I, J, K and L while ignoring the formulas that I have entered in those columns?