DIV/O when using Average function

[kspence703]

Trying to get an average of one set of data if the other set of data is greater than or equal to another number (cell referenced). I am getting a #DIV/0 error. Right now I have it written as averageif(A3:A27,">=A55",B3:B27). This returns a #DIV/0 error. I have made sure there are not spaces and that they are all numbers. Additionally how would I then write averageifS numbers in range A listed above are greater than 10 but less than 50 finding the average in columne B as referenced above.

???

 

[Marcelo Branco]

Try

=AVERAGEIF(A3:A27,">="&A55,B3:B27)

M.

 

[steve the fish]

Use ">="&A55 not ">=A55" when refering to a cell. For 2nd part:

=AVERAGEIFS(B3:B27,A3:A27,">=10",A3:A27,"<=50")

 

[Scott Huish]

For your second question:
=AVERAGEIFS(B3:B27,A3:A27,">10",A3:A27,"<50")

 

[kspence703]

thanks!