Results 1 to 4 of 4

Formula to find the sum of a set of data based on specific criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Formula to find the sum of a set of data based on specific criteria

    I'm looking for some help to automate a data table I set up in excel. I need the formula to look through a bunch of raw data I have, and add quantities in each row, but only from the rows that have the same machine numbers. I attached the document of raw data I've collected, and on a separate tab, an organized table. I would like this table to automatically be updated with the appropriate data, as I enter it as raw data. I've included details in text boxes in the results tab, that should better explain this. Please let me know if you need any additional explaination, as I realize it was difficult to explain in a simple manner. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Enter data into specific row in data table based on multiple criteria
    By bberger1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2013, 11:04 AM
  2. Need to sort data based on criteria, and specific format
    By wparker80 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 05:16 PM
  3. Selection of Data in an Array Based on Specific Criteria
    By Christopher.Belanger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2012, 10:41 AM
  4. Find earliest date based on specific criteria in other columns
    By cat2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2011, 11:50 AM
  5. Formula to sum cells based on specific criteria
    By Socrates in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-26-2009, 11:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1