averaging data in multiple columns
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
|