If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Looking up values in a table
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, |
#2
|
|||
|
|||
Looking up values in a table
On Mon, 26 Apr 2010 11:55:01 -0700, Aris
wrote: 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 |
#3
|
|||
|
|||
Looking up values in a table
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 wrote: Hi, [quoted text clipped - 16 lines] Thank you, Try this formula: =SUMPRODUCT(--(A:A="Feb"),--(B:B="John"),C:C) Hope this helps / Lars-Ã…ke -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/201004/1 |
Thread Tools | |
Display Modes | |
|
|