| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create an AVERAGEIF function.
Introduce an AVERAGEIF function in Excel. Can currently do it, but only
combining SUMIF and COUNTIF... clumsy. |
|
#2
|
|||
|
|||
|
=AVERAGE(IF(A1:A100=condition,A1:A100))
enter as an array formula, that is commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "as" wrote in message ... Introduce an AVERAGEIF function in Excel. Can currently do it, but only combining SUMIF and COUNTIF... clumsy. |
|
#3
|
|||
|
|||
|
If you want something like an average of column C when Column A is a name
Try =Average(if(A1:A50="name",C1:C50,"") entered as Array (Control Shift Enter) The Criteria can be almost anything you want it to be. This also works for Standard deviations etc. "as" wrote: Introduce an AVERAGEIF function in Excel. Can currently do it, but only combining SUMIF and COUNTIF... clumsy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion | Excel Worksheet Functions | |||
| Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
| AVERAGEIF Function out there? | Excel Discussion (Misc queries) | |||
| create function | Excel Worksheet Functions | |||
| How do I create a multi formula IF function in Excel? | Excel Worksheet Functions | |||
Linear Mode
