For any particular mth/yr, you could capture it unambiguously, like this
In say, E2, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=AVERAGE(IF(--(TEXT(B2:B10,"mmmyy")="Jul09"),D2:D10))
Above presumes dates in col B are real dates
Adapt to suit the actual extents of your data

Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"mbr" wrote:
i need to be able to capture the average of amounts in column d if column b
is between 1/7/9 and 31/7/9. can it be done?