Try

=AVERAGEIF(Sheet1!G:G,"condo",F:F)

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

How do I create an AVERAGEIF formula, using the data from one worksheet and
putting the result on another worksheet? I need the average of Sales Price,
when the Style is Condo.

The formula will be on sheet 2.

The data is on sheet 1. The table name is SalesData3. Column F is Sales
Price and column G is Style.



--
Shelina