New guy here:
There's probably something really simple I'm missing, but I'm at a loss on this.
I have four columns of data I'm working with: Carrier Name, Product Name, Number of Lives, and # of Days Before Completed (I work in insurance). I've been able to average the "# of days" column by carrier and product use DAVERAGE, but I'm also trying to do it by Number of Lives.
I need to set up my criteria so that instead of looking for a specific value, it is averaging only the "# of Days" that correspond to a range of # of lives (2 to 14, 15 to 25, etc.).
I'm horrible at explaining this, so let me know if I'm making no sense and I can upload the sheet I'm working on.
Bookmarks