Table Lookup
 

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?

Table Lookup
 

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.

"Alister Gough" wrote:

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?

Table Lookup
 

Try: =SUMPRODUCT((B1:B4="Holdem")*(C1:C4))
Micky


"Alister Gough" wrote:

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?

Table Lookup
 

Use SUMIF()

=SUMIF(B1:B100,"Holdem",C1:C100)

--
Jacob


"Alister Gough" wrote:

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?

Table Lookup
 

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.

Table Lookup
 

Thank you Jacob that worked a treat.

"Jacob Skaria" wrote:

Use SUMIF()

=SUMIF(B1:B100,"Holdem",C1:C100)

--
Jacob


"Alister Gough" wrote:

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?

Table Lookup
 

Sorry, but my "Cystal Ball" didn't come back from the cleaner, yet, therefor
I can't refer to information one holds "close to his chest" - however, may I
suggest that you try again as this works 123%:
http://img64.imageshack.us/img64/346/nonamer.png
Micky


"Alister Gough" wrote:

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.