Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
Hi
Show what your data looks like and what it is you are trying to Sum. -- Regards Roger Govier "T-J" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i combine a lookup and a sumif formula?
Hi
Mike has posted you the solution. -- Regards Roger Govier "T-J" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine SUMIF and SUMPRODUCT | Excel Worksheet Functions | |||
Help - I need to combine both a SUMIF and COUNTIF into one formula | Excel Worksheet Functions | |||
Combine Sumif | Excel Discussion (Misc queries) | |||
How i can create a formula that combine subtotals and sumif | Excel Worksheet Functions | |||
Combine Indirect and Sumif | Excel Worksheet Functions |