Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2015
    Posts
    8
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Interrogating data

    Hi, first up i am a real novice using excel, but keen to learn.
    I need to sort a heap of data. i have been trying to get the correct answer using SUMIFS, but just cannot work it out. Or maybe it's not the correct way.

    I have attached a basic set of figures and explanation of what i require. I hope i have explained myself?HELP!.xlsx
    Any assistance will be greatly appreciated.
    Cheers Tim

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi

    Welcome to the Lounge!
    You nearly got it right.

    ..the formula you need is =SUMIF(C:C,1,D:D)

    see attached

    zeddy
    Attached Files Attached Files

  3. The Following User Says Thank You to zeddy For This Useful Post:

    Timboc (2015-06-04)

  4. #3
    New Lounger
    Join Date
    Jun 2015
    Posts
    8
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks so much Zeddy, I knew it would be simple, just couldn't see it. I will try first thing in the morning midnight here. Cheers. Tim

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    Or if you want to stick with SUMIFS then

    Code:
    =SUMIFS(D:D,C:C,1)
    would work as well.

    Maud

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    Timboc (2015-06-04)

  7. #5
    New Lounger
    Join Date
    Jun 2015
    Posts
    8
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Maud, looks like it works too.
    All the best Tim

  8. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 646 Times in 590 Posts
    Code:
    =SUMPRODUCT((D4:D11)*(C4:C11=1)) will also work.
    Maud

  9. The Following User Says Thank You to Maudibe For This Useful Post:

    Timboc (2015-06-04)

Posting Permissions

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