Would you somebody please tell me what the formula is:

If ByDay!a1:a65000 = "DFW" then do an average of the percentages found in
ByDay!d1:d65000