Table Lookup

  • Thread starter Thread starter Alister Gough
  • Start date Start date
A

Alister Gough

I need help with a lookp I need to do. This lookup needs to lookup a table
that may contain the same data more than once and then add the values
together.

E.g. The table might look like this:

Table Game Hours
PK01 Holdem 8
PK02 Omaha 3
PK03 Draw 11
PK04 Holdem 2

So the formula I need would have to lookup the value which might be holdem
and return the value 10 (8 + 2).

Is there anyway t do this?
 
Try: =SUMPRODUCT((B1:B4="Holdem")*(C1:C4))
Micky
 
Assuming Holden is in Col B and hours in Col C
Try
=SUMPRODUCT(--(B1:B100="Holdem"),(C1:C100))

Change 100 to your last data row number.
 
Hi guys,

Thanks for the help, unfortunately they didn't work. They both come up with
the error message #VALUE!

I think may have left out some important things I forgot to mention.

1st the value I am looking up is on a different sheet.
2nd the value being looked up is part of a drop down menu so that everyone
enters the data the same. The hours are worked out as part of a formula.
 
Back
Top