×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SUMIF Problem

SUMIF Problem

SUMIF Problem

(OP)
I need to convert an .mdi file to excel.  I first copied the information to a text file, then to excel.  Doing this exercise allowed me to maintain the columns needed for a spreadsheet.  I am using excel as a database, somewhat.
I put the converted information in a sheet.  In another sheet I am pulling selected information out using "SUMIF" statements.  The number format in the column I am searching has the area of the job as the first digit.  The remaining digits are cost codes.  The number 150515 would be area 1 and 50501 would be the cost code for safety.  In another column is the cost.  I use wild cards to add cost in several different areas.  As I go through this exercise 20-30 times I noticed some of the requested values are zero when there should be a dollar figure.  Some function properly and some do not.  If I put the area digit in the formula, I receive the proper value.  But that is only for that one area.  I have 10 areas and want to know the total of the cost in all areas for a given cost code.  I've tried formatting the cells.  I've tried retyping the value.  I don't understand why the formula works on some, but not others.
 

RE: SUMIF Problem

(OP)
I fixed the problem, but don't understand why or how.
I formated all the cells the same.  Then I had to open each cell, as to edit the cell.  All formulas are functioning properly.  I'm glad I had only 500 cells to do that to.  There has got to be a better way.  If you know, please reply.
Thanks

RE: SUMIF Problem

(OP)
Thanks IDS.  That took care of it.  I was regretting next week when this excercise repeated itself.

RE: SUMIF Problem

I do something similar when this comes up.

I multiply everything by one, I never thought of adding zero.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources