Likes Likes:  0
Results 1 to 6 of 6

Thread: Looking for basic formula advice

  1. #1
    New Member
    Join Date
    Feb 2014
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Looking for basic formula advice

    I have to take report exports from Salesforce and calculate things like total sales, number of orders, etc... and I have basic sumifs & countifs formulas for most of the statistics (for date ranges, or product type etc..). My problem is that the raw data reports are structured differently depending on who provides the data. The good news is the column headers are always the same. I have some basic ideas; however, can someone give me advice on what's the best option for creating a more advanced formula, say sumifs, that scans the columns first and only pulls data from a specific header?

  2. #2
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,434
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Looking for basic formula advice

    Use INDEX() accompanied by the Match()
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

  3. #3
    New Member
    Join Date
    Feb 2014
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Looking for basic formula advice

    Thanks, that was something I didn't consider. Index and Match are on my list of "need to learn". I've played around with them but really need to find some good tutorials.

    Quote Originally Posted by jim may View Post
    Use INDEX() accompanied by the Match()

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    21,861
    Post Thanks / Like
    Mentioned
    357 Post(s)
    Tagged
    36 Thread(s)

    Default Re: Looking for basic formula advice

    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 2003 & 2013 on Win 7

  5. #5
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,025
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Looking for basic formula advice

    Here is an example of similar one posted here from a few years ago: https://www.mrexcel.com/forum/excel-...mn-header.html
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  6. #6
    New Member
    Join Date
    Feb 2014
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Looking for basic formula advice

    So then could I build a list of formulas on sheet 2 to sumifs sales by product and date as well as countifs number of projects by date that will scan sheet 1 and pull the information?

    Basically I'm looking to build out a page of calculations on sheet 2 and set it up where I just insert the report as sheet1 and everything auto calculates.

    Just trying to clarify before I go down the Index Match path.

    Thanks again everyone.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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