I'm looking for a formula to lookup criteria in column A and average the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have been
sold
in a given year and I will be adding addtional months as time progresses and
do not want to have to adjust my range or formula each time a new months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have been
sold
in a given year and I will be adding addtional months as time progresses
and
do not want to have to adjust my range or formula each time a new months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad

Yes. Data in columns B, C, D and E do represent months. What I'm trying to
do for example is see what the average number of "CATS" sold is during these
4 months. I'd like create a formula that looks up "CATS" and tells me the
average is 150 based on a data range which would do the calculation
(200+300+100+0)/4.



"T. Valko" wrote:

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have been
sold
in a given year and I will be adding addtional months as time progresses
and
do not want to have to adjust my range or formula each time a new months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad


.

Ok, the formula I suggested will do just that.

Just change the range/cell references to suit your layout.

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
Yes. Data in columns B, C, D and E do represent months. What I'm trying
to
do for example is see what the average number of "CATS" sold is during
these
4 months. I'd like create a formula that looks up "CATS" and tells me the
average is 150 based on a data range which would do the calculation
(200+300+100+0)/4.



"T. Valko" wrote:

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average
the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have
been
sold
in a given year and I will be adding addtional months as time
progresses
and
do not want to have to adjust my range or formula each time a new
months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad


.

Thanks so much. This is great.

"T. Valko" wrote:

Ok, the formula I suggested will do just that.

Just change the range/cell references to suit your layout.

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
Yes. Data in columns B, C, D and E do represent months. What I'm trying
to
do for example is see what the average number of "CATS" sold is during
these
4 months. I'd like create a formula that looks up "CATS" and tells me the
average is 150 based on a data range which would do the calculation
(200+300+100+0)/4.



"T. Valko" wrote:

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average
the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have
been
sold
in a given year and I will be adding addtional months as time
progresses
and
do not want to have to adjust my range or formula each time a new
months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad


.



.

Sorry. 1 more question. What if I want to take the average of both "DOGS"
and "CATS" sold?

Thanks,

Brad

"T. Valko" wrote:

Ok, the formula I suggested will do just that.

Just change the range/cell references to suit your layout.

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
Yes. Data in columns B, C, D and E do represent months. What I'm trying
to
do for example is see what the average number of "CATS" sold is during
these
4 months. I'd like create a formula that looks up "CATS" and tells me the
average is 150 based on a data range which would do the calculation
(200+300+100+0)/4.



"T. Valko" wrote:

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average
the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have
been
sold
in a given year and I will be adding addtional months as time
progresses
and
do not want to have to adjust my range or formula each time a new
months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad


.



.

Try this...

A10 = dogs
B10 = cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0),INDEX(B 2:M4,MATCH(B10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
Sorry. 1 more question. What if I want to take the average of both
"DOGS"
and "CATS" sold?

Thanks,

Brad

"T. Valko" wrote:

Ok, the formula I suggested will do just that.

Just change the range/cell references to suit your layout.

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
Yes. Data in columns B, C, D and E do represent months. What I'm
trying
to
do for example is see what the average number of "CATS" sold is during
these
4 months. I'd like create a formula that looks up "CATS" and tells me
the
average is 150 based on a data range which would do the calculation
(200+300+100+0)/4.



"T. Valko" wrote:

It's not real clear what you're wanting to do.

Do columns B, C, D and E represent months?

See if this does what you want...

Data in the range A2:M4

A10 = Cats

=AVERAGE(INDEX(B2:M4,MATCH(A10,A2:A4,0),0))

--
Biff
Microsoft Excel MVP


"brad1824" wrote in message
...
I'm looking for a formula to lookup criteria in column A and average
the
results in columns B, C, D, E, etc.

For example I would like to know the average of how many "CATS" have
been
sold
in a given year and I will be adding addtional months as time
progresses
and
do not want to have to adjust my range or formula each time a new
months
worth of data is added. For example.

column A column B column C column D column E

DOGS 100 200 150 50
CATS 200 300 100 0
FISH 50 100 200 100

Any help is truly appreciated.

Thanks,

Brad


.



.