How do i combine a lookup and a sumif formula? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              T-J 7/13/2007 3:17 AM PST   Question   Can anybody hep me, I am trying to combine a SUMIF formula and a HLOOKUP to return tha combined total of similar items in a table. Thanks     Was this post helpful to you?         Reply |   Top           Mike H  7/13/2007 3:23 AM PST   An indication of what the table looks like would be helpful Mike "T-J" wrote: > Can anybody hep me, I am trying to combine a SUMIF formula and a HLOOKUP to > return tha combined total of similar items in a table. > > Thanks     Was this post helpful to you?         Reply |   Top           T-J 7/13/2007 3:29 AM PST   Hi Mike I want to lookup and sum the total compensation in a particular year: eg: 2006 2007 Compensation 1000 2000 Compensation 800 900 This is obvioulsy a simplified version but is essentially what i need to do. Thanks for your prompt response. T-J "Mike H" wrote: > An indication of what the table looks like would be helpful > > Mike > > "T-J" wrote: > > > Can anybody hep me, I am trying to combine a SUMIF formula and a HLOOKUP to > > return tha combined total of similar items in a table. > > > > Thanks     Was this post helpful to you?         Reply |   Top           Mike H  7/13/2007 3:51 AM PST   Answer   Possibly:- =SUMPRODUCT((A2:A20="Compensation")*(B1:E1=2002)*(B2:E20)) The year to sum could be a cell reference. Mike "T-J" wrote: > Hi Mike > > I want to lookup and sum the total compensation in a particular year: > > eg: > 2006 2007 > Compensation 1000 2000 > Compensation 800 900 > > > This is obvioulsy a simplified version but is essentially what i need to do. > > Thanks for your prompt response. > > T-J > "Mike H" wrote: > > > An indication of what the table looks like would be helpful > > > > Mike > > > > "T-J" wrote: > > > > > Can anybody hep me, I am trying to combine a SUMIF formula and a HLOOKUP to > > > return tha combined total of similar items in a table. > > > > > > Thanks     Was this post helpful to you?         Reply |   Top           Francois via OfficeKB.com 7/13/2007 4:35 AM PST   Mike H wrote: >Possibly:- > >=SUMPRODUCT((A2:A20="Compensation")*(B1:E1=2002)*(B2:E20)) > >The year to sum could be a cell reference. > >Mike > >> Hi Mike >> >[quoted text clipped - 19 lines] >> > > >> > > Thanks Thanks Mike, That's helped me with a problem I had -- Message posted via http://www.officekb.com     Was this post helpful to you?         Reply |   Top           T-J 7/13/2007 5:09 AM PST   Thanks Mike, much appreciated. All sorted now. T-J "Mike H" wrote: > Possibly:- > > =SUMPRODUCT((A2:A20="Compensation")*(B1:E1=2002)*(B2:E20)) > > The year to sum could be a cell reference. > > Mike > > "T-J" wrote: > > > Hi Mike > > > > I want to lookup and sum the total compensation in a particular year: > > > > eg: > > 2006 2007 > > Compensation 1000 2000 > > Compensation 800 900 > > > > > > This is obvioulsy a simplified version but is essentially what i need to do. > > > > Thanks for your prompt response. > > > > T-J > > "Mike H" wrote: > > > > > An indication of what the table looks like would be helpful > > > > > > Mike > > > > > > "T-J" wrote: > > > > > > > Can anybody hep me, I am trying to combine a SUMIF formula and a HLOOKUP to > > > > return tha combined total of similar items in a table. > > > > > > > > Thanks     Was this post helpful to you?         Reply |   Top           Roger Govier 7/13/2007 3:37 AM PST   Hi Show what your data looks like and what it is you are trying to Sum. -- Regards Roger Govier "T-J" <T-J@discussions.microsoft.com> wrote in message news:233A9E68-C2EE-4F0F-8942-0BBC6CC1F551@microsoft.com... > Can anybody hep me, I am trying to combine a SUMIF formula and a > HLOOKUP to > return tha combined total of similar items in a table. > > Thanks     Was this post helpful to you?         Reply |   Top           T-J 7/13/2007 3:51 AM PST   Hi Roger, I want to lookup and sum the total compensation in a particular year: eg: 2006 2007 Compensation 1000 2000 Compensation 800 900 This is obvioulsy a simplified version but is essentially what i need to do. Thanks for your prompt response. T-J "Roger Govier" wrote: > Hi > Show what your data looks like and what it is you are trying to Sum. > > -- > Regards > > Roger Govier > > > "T-J" <T-J@discussions.microsoft.com> wrote in message > news:233A9E68-C2EE-4F0F-8942-0BBC6CC1F551@microsoft.com... > > Can anybody hep me, I am trying to combine a SUMIF formula and a > > HLOOKUP to > > return tha combined total of similar items in a table. > > > > Thanks > > >     Was this post helpful to you?         Reply |   Top           Roger Govier 7/13/2007 5:19 AM PST   Hi Mike has posted you the solution. -- Regards Roger Govier "T-J" <TJ@discussions.microsoft.com> wrote in message news:BA99366D-6D58-4C71-A12F-E10883C5EDF2@microsoft.com... > Hi Roger, > > I want to lookup and sum the total compensation in a particular year: > > eg: > 2006 2007 > Compensation 1000 2000 > Compensation 800 900 > > > This is obvioulsy a simplified version but is essentially what i need > to do. > > Thanks for your prompt response. > > T-J > > > "Roger Govier" wrote: > >> Hi >> Show what your data looks like and what it is you are trying to Sum. >> >> -- >> Regards >> >> Roger Govier >> >> >> "T-J" <T-J@discussions.microsoft.com> wrote in message >> news:233A9E68-C2EE-4F0F-8942-0BBC6CC1F551@microsoft.com... >> > Can anybody hep me, I am trying to combine a SUMIF formula and a >> > HLOOKUP to >> > return tha combined total of similar items in a table. >> > >> > Thanks >> >> >>     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies