Sumif or Vlookup based on several criteria

Hi … using Excel 2010

I’m looking to get a sum of 5 different numbers referenced by “codes”, and wondering if there is an easy way to do this without having a really long formula that is repeated.

For instance, the data table the info is pulling from is as follows:

A                        B                          C                        D                        E

1000                   129                       139                    149                     159

1005                   5                           20                      30                      40

1015                   90                          0                        180                    270

 

I’m trying to have a simlified formula that will look up the “codes” in column A, and sum the corresponding values in column B.

Thanks!

1,832 thoughts on “Sumif or Vlookup based on several criteria

  1. deposit joker slot

    Hi, I do think this is an excellent blog. I stumbledupon it 😉 I am going to return once again since i have book marked it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  2. qq

    It’s hard to find knowledgeable people for this subject, but you sound like you know what you’re talking about! Thanks

  3. thewatchseries movies

    A motivating discussion is definitely worth comment. I do believe that you should write more on this topic, it may not be a taboo matter but generally people don’t talk about such topics. To the next! Best wishes!!

  4. judi bola

    I’ve learn some good stuff here. Certainly value bookmarking for
    revisiting. I wonder how so much effort you put to make such
    a magnificent informative web site.

  5. daftar joker123

    Hey there! I just would like to offer you a big thumbs up for the great information you have right here on this post. I’ll be coming back to your website for more soon.

  6. login joker123

    Aw, this was an extremely good post. Finding the time and actual effort to produce a very good article… but what can I say… I procrastinate a lot and don’t seem to get anything done.

  7. yify sites

    I need to to thank you for this very good read!! I certainly enjoyed every bit of it. I’ve got you book marked to check out new things you post…

  8. jual obat kuat di bandung

    Having read this I thought it was really enlightening. I appreciate you taking the time and effort to put this informative article together. I once again find myself spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

  9. Lexus888 Mobile

    You’re so cool! I do not suppose I have read something like that
    before. So nice to discover another person with original thoughts on this subject matter.
    Really.. thanks for starting this up. This website is something that is needed on the internet, someone with a little originality!

  10. Truck Scales

    Hello, i think that i saw you visited my weblog so i got here to go back
    the favor?.I am attempting to find issues to improve my
    site!I guess its ok to make use of a few of your ideas!!

Leave a Reply

Your email address will not be published. Required fields are marked *