AVERAGEIF and Total Sum Question

[dmill8023]

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.

 

[JoeMo]

Assuming Dashboard!$C158 contains the day you want the average for and that you are using Excel 2007 or a later version, maybe:

=IFERROR(AVERAGEIF('Raw Data'!$AM$2:$AM$100,Dashboard!$C158,'Raw Data'!$AI$2:$AI$100),0)

 

[dmill8023]

Thank you JoeMO

 

[JoeMo]

Thank you JoeMO

You are welcome - thanks for the reply.