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
|