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

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

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

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

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

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

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

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

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