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.


Leave a Reply

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