Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

What VLOOKUP & SUM formula would I use ?

Latest post Fri, Dec 12 2014 12:07 PM by PeterG. 6 replies.
  • Fri, Sep 5 2014 8:40 AM

    • George3578
    • Top 500 Contributor
    • Joined on Fri, Sep 5 2014
    • Posts 5
    • Points 89

    What VLOOKUP & SUM formula would I use ?

    Hi

    I have two worksheets.

    One listing all days against a individual contract e.g.

    Contracts             Days

    1234                       1

    1234                       4

    1234                       2

    1234                       9

    1235                       1

    1235                       6

    1235                       0

    1235                       11

    1236                       7

    1236                       2

    1236                      20

    1237                       1

    1237                       7

    1237                       5

    1237                       5

     

    and the other where I want to look this days total up for that contract e.g.

     

    Contract              Total days

    1234                       16

    1235                       18

    1236                       29

    1237                       18

      

    What VLOOKUP & SUM formula would I use ?

    Thanks

     

     

    Filed under: , , ,
    • Post Points: 21
  • Fri, Sep 5 2014 10:21 AM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Re: What VLOOKUP & SUM formula would I use ?

    You can use the SUMIF function for this - see http://office.microsoft.com/en-gb/excel-help/sumif-function-HP010062465.aspx.

    Peter

    • Post Points: 21
  • Fri, Sep 5 2014 10:24 AM In reply to

    • George3578
    • Top 500 Contributor
    • Joined on Fri, Sep 5 2014
    • Posts 5
    • Points 89

    Re: What VLOOKUP & SUM formula would I use ?

    Thanks Peter but I cannot work out which bits go where in the ofrmula, can you (or someone) write the specific formula for me please.

     

    Thanks

    • Post Points: 21
  • Fri, Sep 5 2014 2:05 PM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Re: What VLOOKUP & SUM formula would I use ?

    I've attached a sample workbook.

    Your data is on the Data sheet, the summary SUMIF formulas on the Summary sheet, and an alternative pivot table summary on the PivotTable sheet.

    If you are completely new to Excel, I strongly recommend that you get hold of an introductory book and spend a few hours studying how simple formulas and pivot tables work - the time you invest will be amply rewarded.

    Peter

    • Post Points: 21
  • Tue, Sep 9 2014 6:55 AM In reply to

    • George3578
    • Top 500 Contributor
    • Joined on Fri, Sep 5 2014
    • Posts 5
    • Points 89

    Re: What VLOOKUP & SUM formula would I use ?

    Thank you sooooo much - you are a godsend!

     

    Sarah

    • Post Points: 5
  • Fri, Dec 12 2014 11:29 AM In reply to

    • George3578
    • Top 500 Contributor
    • Joined on Fri, Sep 5 2014
    • Posts 5
    • Points 89

    Re: What VLOOKUP & SUM formula would I use ?

    Hi

     

    Do you know how i can quickly nd easily sort my worksheets on a document in 2010 Excel?

    • Post Points: 21
  • Fri, Dec 12 2014 12:07 PM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Re: What VLOOKUP & SUM formula would I use ?

    If you have a new query, then you should start a new thread rather than simply tagging your question on to a previous discussion thread.

    A simple google search brings up this page

    http://support.microsoft.com/KB/812386

    where there is some VBA code for alphabetically sorting worksheets in a workbook.

    Peter

    • Post Points: 5
Page 1 of 1 (7 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.