Im trying to use the daverage function to average the cost of claims where total damages is between say £1001 and 5001. Im having difficulty setting up a suitable criteria range, as saying less than 5001 automatically includes all figures. Any ideas?
thanks![]()
Bookmarks