Averageif formulae

[b19upj]

Hi.
I have a simple question on an averageif statement that is ending in an error code for me.
I have in worksheet of data. I have made a pivot based on the data and in
column A is the postcode,
column B is the Average for the rent,
column C is the Standard Deviation of the rent

All easy to produce using the values selector in the pivot table.
Now i need to find and average all rents that fall below a calculated number. This number is the average rent + the standard deviation amount but i am getting an #Div/0 error.
There are no rent values of 0 though.
My formulae to work out average rent when lower than the average+standard deviation on row 2 is =averageif(B2:B3000,"<c2").
I was then hoping to copy it down all the rows in my worksheet, but it is giving me this error.
Any ideas why?
Or does anyone know how to write a formulae saying AVERAGE [a specific number of rows in a column] IF [lower than a value given in another cell along the same row].

Thanks</c2").>

 

[oldbrewer]

on row 2 is =averageif(B2:B3000,"<c2").
I was then

typo ?</c2").>

 

[b19upj]

Sorry, it wont let me post the furmulae. Ive tried 4 times and it posts it incomplete...

My formulae that isnt working is
=averageif(B2:B3000," lower-than-symbol C2 ")<c3 ")<c2")<c2")<="" html=""></c3>