Looking up values in a table

A

Aris

Hi,

How do you search for data from a table having 2 criterias?

Example:
Month Name Score
Jan John 3
Jan Mark 2
Jan Tom 4
Feb John 5
Feb Mark 3
Feb Tom 4
Mar John 5
Mar Mark 4
Mar Tom 3


Let's say i want to look for the score for john in Feb. What formula could I
use?

Thank you,
 
L

Lars-Åke Aspelin

Hi,

How do you search for data from a table having 2 criterias?

Example:
Month Name Score
Jan John 3
Jan Mark 2
Jan Tom 4
Feb John 5
Feb Mark 3
Feb Tom 4
Mar John 5
Mar Mark 4
Mar Tom 3


Let's say i want to look for the score for john in Feb. What formula could I
use?

Thank you,

Try this formula:

=SUMPRODUCT(--(A:A="Feb"),--(B:B="John"),C:C)

Hope this helps / Lars-Åke
 
E

edvwvw via OfficeKB.com

I am not sure that this will work as you need to define the range for
SUMPRODUCT

Each element needs to be the same size

=SUMPRODUCT(--(A1:A10="Feb"),--(B1:B10="John"),C1:C10)

edvwvw

Lars-Ã…ke Aspelin said:
[quoted text clipped - 16 lines]
Thank you,

Try this formula:

=SUMPRODUCT(--(A:A="Feb"),--(B:B="John"),C:C)

Hope this helps / Lars-Ã…ke
 

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

Top