| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGEIF
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGEIF
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGEIF
I assume you are working with 2007. Incase you are working with 2007
try the below array formula ..Entered using Ctrl+Shift+Enter =AVERAGE(IF((Sheet1!G1:G100="condo")* (ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGEIF
I mean if you are ***not*** working with 2007/2010 you need to try out the
array formula. If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: I assume you are working with 2007. Incase you are working with 2007 try the below array formula ..Entered using Ctrl+Shift+Enter =AVERAGE(IF((Sheet1!G1:G100="condo")* (ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGEIF
The first one worked, thanks! I'm using 2007.
-- Shelina "Jacob Skaria" wrote: I mean if you are ***not*** working with 2007/2010 you need to try out the array formula. If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: I assume you are working with 2007. Incase you are working with 2007 try the below array formula ..Entered using Ctrl+Shift+Enter =AVERAGE(IF((Sheet1!G1:G100="condo")* (ISNUMBER(Sheet1!F1:F100)),Sheet1!F1:F100)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGEIF | Excel Worksheet Functions | |||
| Help with Averageif Formula (don't think I should use Averageif) | Excel Discussion (Misc queries) | |||
| AVERAGEIF | Excel Worksheet Functions | |||
| averageif | Excel Worksheet Functions | |||
| averageif | Excel Discussion (Misc queries) | |||
Linear Mode
