=IF(COUNTIF(a1:a65000,"dfw")=65000,AVERAGE(d1:d650 00),"")

But I'm not sure that's what you're looking to do. The above says calculate
the average in the range D1:D65000 only if all cells in the range A1:A65000
contain "DFW".

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Tammy" wrote:

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