You could point Topper's array suggestion to the source cells in col A
Eg in C1, array-entered (press CTRL+SHIFT+ENTER):
=AVERAGE(IF($A$1:$A$100=A1,$B$1:$B$100))
Copy down (Adapt the ranges to suit before you copy down)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zilla" wrote in message
...
Thanks but this will be tedious since you hard-coded "2",
which is just an example value. So if I change "2" to "19",
I'd have to change it in ALL the formulas...

"Toppers" wrote in message
...
=AVERAGE(IF($A$1:$A$100=2,$B$1:$B$100))

entered with Ctrl+Shift+Enter