hi tammy,

u have new condition but u can try this also Average + IF functions - array
formula

=AVERAGE(if(((A1:A65000="DFW")*(F1:F650000%)),F1: F65000))
press CTRL-SHFT-ENTER not just enter.

or u can try also sumproduct + countif functions

regards
*****
birds of the same feather flock together..



"Tammy" wrote:

thanks guys - i need to add one more twist. I do not want it to include in
the average where there is a value of 0%. can you please tell me how to add
that?

"driller" wrote:

hi Tammy,
try it as array formula..
=AVERAGE(if(A1:A65000="DFW",F1:F65000))
press CTRL-SHFT-ENTER not just enter.
regards
--
*****
birds of the same feather flock together..



"Tammy" wrote:

what's wrong with this statement?

=AVERAGE(if A1:A65000="DFW",F1:F65000)

i want my spreadsheet to give me the average of the percentages listed in
column F where column A = dfw ...
thanks