How do i combine a lookup and a sumif formula?

G

Guest

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
 
G

Guest

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
 
G

Guest

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
 
G

Guest

Possibly:-

=SUMPRODUCT((A2:A20="Compensation")*(B1:E1=2002)*(B2:E20))

The year to sum could be a cell reference.

Mike
 
F

Francois via OfficeKB.com

Mike said:
Possibly:-

=SUMPRODUCT((A2:A20="Compensation")*(B1:E1=2002)*(B2:E20))

The year to sum could be a cell reference.

Mike
[quoted text clipped - 19 lines]

Thanks Mike, That's helped me with a problem I had
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top