Hello all,

I have a table which contains quite a few entries. What I am trying to
do is get a number (from this table) based on 3 different criterias.
For example, given that a person is in "Group 2", and the name of that
person is "Larry", what are his sales figures for "Tuesday"? Just to be
clear, Larry can be in more than one group, and have sales figures for
every day. The table from which we get this info has the following as
fields: 'GroupNumber", "Sale Rep Name", "Monday", "Tuesday",
Wednesday", Thursday", and "Friday"...the days represent sales figures.

I know I can get answers based on two criteria using Index and Match
functions...how about for 3 or more?

Thanks for any and all help!

As a guess you are looking for the sumproduct formula... Give this link a
look...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


" wrote:

Hello all,

I have a table which contains quite a few entries. What I am trying to
do is get a number (from this table) based on 3 different criterias.
For example, given that a person is in "Group 2", and the name of that
person is "Larry", what are his sales figures for "Tuesday"? Just to be
clear, Larry can be in more than one group, and have sales figures for
every day. The table from which we get this info has the following as
fields: 'GroupNumber", "Sale Rep Name", "Monday", "Tuesday",
Wednesday", Thursday", and "Friday"...the days represent sales figures.

I know I can get answers based on two criteria using Index and Match
functions...how about for 3 or more?

Thanks for any and all help!

Fastest might be to transfer the range to an array and just loop through the
array. Another good option is to use SQL.

RBS

wrote in message
oups.com...
Hello all,

I have a table which contains quite a few entries. What I am trying to
do is get a number (from this table) based on 3 different criterias.
For example, given that a person is in "Group 2", and the name of that
person is "Larry", what are his sales figures for "Tuesday"? Just to be
clear, Larry can be in more than one group, and have sales figures for
every day. The table from which we get this info has the following as
fields: 'GroupNumber", "Sale Rep Name", "Monday", "Tuesday",
Wednesday", Thursday", and "Friday"...the days represent sales figures.

I know I can get answers based on two criteria using Index and Match
functions...how about for 3 or more?

Thanks for any and all help!