Hello All! I am looking for some assistance. I am looking to do an average for travel times based on a certain day of the week. For example I keep the number of travel days in range AI2:AI100. My days are indicated in column AM2:AM100. Currently my formula is =AVERAGEIF('Raw Data'!$AM$2:$AM$100,Dashboard!$C158,'Raw Data'!$AI$2:$AI$100) but I don't have and "Sunday" values in range AM2:AM100. Therefore my sum of all the days are returning #DIV/0! Can someone please help? If further information is needed please let me know.