AVg question

[Guest]

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

 

[Guest]

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

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

Dave

 

[Guest]

thats exactly what I want. thanks.

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

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

Dave

 

[Guest]

this is an array formula that you commit by pressing Ctrl-Shift-Enter all at
once

=average(if(ByDay!a1:a65000 = "DFW",ByDay!d1:d65000))

 

[Guest]

Try:

=AVERAGE(IF(ByDay!A1:A65000="DFW",ByDay!D165000))

Enter with Ctrl+Shift+Enter

 

[Guest]

thank you everyone! The first response, when I entered it, gave me a blank
result. But =AVERAGE(IF(ByDay!A1:A65000="DFW",ByDay!D165000)) CSE worked!

thank you thank you

 

[Guest]

Yeah I didn't think my response would help you. As I say, it would only
return the average if ALL cells in A1:A65000 contained "DFW"

Dave