PDA

View Full Version : Solved: Average of Values in Column E for each value in Column B - help



Foxtrot
04-25-2009, 09:54 AM
I have a list of vendors (organized by vendor number) in Column B of my worksheet. Column E is a list of the # of days it took the vendor to get product to me.

I need a macro that will search for like values in column B and then average the values in Column E of the corresponding Rows. I need it to report the result in Column F in each of those Rows.

Bob Phillips
04-25-2009, 09:59 AM
Use this array formula

=AVERAGE(IF($B$2:$B$17=B2,$E$2:$E$17))

Foxtrot
04-25-2009, 10:20 AM
Thanks xld, I'll try that.

How does the "$" function in that array?

Foxtrot
04-25-2009, 10:38 AM
Actually, that doesn't work right.

The result is the average of every cell value in Coumn E. I just want the averaged result of the Column E values that correspond with the like values in Column B.

Aussiebear
04-25-2009, 10:56 AM
Please use Control Shift Enter when you enter the formula. The results will then show A10256 has an average of 7.75 days, B10110 an average of 8.75 etc.