Microsoft Office Excel Ignoring Formulas

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?
Who is Participating?
Naresh PatelConnect With a Mentor TraderCommented:
Hi submarinerssbn731,

Use this Formula for Cell N2

Open in new window

Step 1 Copy past in Cell N2 it will appear like #NUM! don't worry.

Step 2 Click on Formula Bar which is located at upper part of excel next to sign fx

then press all this key together

Open in new window

you wil get your result.

Step 3 Copy past to next cells.

The issue is not with the formula in N2 (=SUM(I2:I1500). The issue is with the formulas in rows I through L.
submarinerssbn731Author Commented:
Thank you very much itjockey! =D Worked like a charm.
Naresh PatelTraderCommented:
thnks.... :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.