Averaging values from rows with identical column

**Broccoli** · 02-15-2012, 01:59 PM

Hello,

I'm hoping there's a way to do this...

I need to compare averages from two datasets that have one column in common... The common column includes 1,934 unique values all of which represent a forested area broken down into 30x30 meter pixels... My worksheet has a total of 10,529 rows.... I need to average the values from column C (RAVG_BA7_class) for all identical column D (setting ID).. I then need to repeat this for column E (FVS_BA7_class) so that I can compare the results from C and E for each setting ID....

Attached is my amazing data... I'm tryin to avoid having to sort the data based on Column D and manual average from there...

Thanks for any help!

**Pete_UK** · 02-15-2012, 03:28 PM

As you are using XL2007, you can use AVERAGEIF for this - put this formula in F2:

=AVERAGEIF($D$2:$D$10529,D2,$C$2:$C$10529)

and this one in G2:

=AVERAGEIF($D$2:$D$10529,D2,$E$2:$E$10529)

then copy down. The attached workbook shows this - I think you had text values in column E, but I have converted these to numeric values.

Hope this helps.

Pete

**Broccoli** · 02-15-2012, 03:47 PM

Pete! Thank you! I think that worked beautifully!

Thanks again and take care!

**Pete_UK** · 02-15-2012, 07:51 PM

You're welcome.

You might like to mark the thread as Solved, and you can also click on the "star" icon in the bottom left corner or any post that has helped you.

Pete

EDIT: scrub that - I see that you have already done so !!