For reporting purposes, the above method works great. If you are just looking for a quick conditional average, I prefer to use Sort or Filter and the highlight the column, look to the Status Bar and it gives you the average, count, and sum all in one place.