# search a column for starting value and average the data corronsponding

1. ## search a column for starting value and average the data corronsponding

Help

Im trying to average the data - like in the attached workbook. I cant figure out how to build a formula to do this automatically, by averaging the data which contains the first 4 values like in column E and matching this to column A and averaging all the data in column B coresponding to Column A correct match.

Does this make sense?

Andre

2. ## Re: search a column for starting value and average the data corronsponding

Check this out
http://www.excelforum.com/excel-gene...ml#post2335323
Of course you are not using dates so change the formula accordingly

3. ## Re: search a column for starting value and average the data corronsponding

thanks ill give it a go

4. ## Re: search a column for starting value and average the data corronsponding

what should be used instead of the month function?

5. ## Re: search a column for starting value and average the data corronsponding

=sumproduct(isnumber(search(e2,\$a\$2:\$a\$18,1))*(\$b\$2:\$b\$18))/sumproduct(--isnumber(search(e2,\$a\$2:\$a\$18,1)))

Seems to get the same results you are looking for