[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Microsoft Office Excel Ignoring Formulas

Posted on 2013-06-28
Medium Priority
441 Views
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?
4-MoCast-Qs.xls
0
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 26

Expert Comment

ID: 39285314
The issue is not with the formula in N2 (=SUM(I2:I1500). The issue is with the formulas in rows I through L.
0

LVL 8

Accepted Solution

Naresh Patel earned 2000 total points
ID: 39285319

Use this Formula for Cell N2
``````=SUM(IF(ISNUMBER(I2:I1500),I2:I1500))
``````

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
``````"ctrl+shift+Enter"
``````

Step 3 Copy past to next cells.

Thanks
4-MoCast-Qs.xls
0

Author Comment

ID: 39285342
Thank you very much itjockey! =D Worked like a charm.
0

LVL 8

Expert Comment

ID: 39285663
thnks.... :)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
###### Suggested Courses
Course of the Month12 days, 22 hours left to enroll