| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Statement to Compute Average
Is there a way to calculate the average of a list of numbers only if another
field in the same row contains a specific character? I have a spreadsheet that contains lines of data with dollar values in one field and either an "M" or an "R" in another field. I want to calculate the average dollar value for only those lines that have a corresponding "M" in them. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Statement to Compute Average
On Fri, 25 Aug 2006 07:01:01 -0700, goudmic
wrote: Is there a way to calculate the average of a list of numbers only if another field in the same row contains a specific character? I have a spreadsheet that contains lines of data with dollar values in one field and either an "M" or an "R" in another field. I want to calculate the average dollar value for only those lines that have a corresponding "M" in them. $ values in B, M/R in A =SUMIF(A:A,"M",B:B)/COUNTIF(A:A,"M") HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Average Array with Dates, <blanks, 0 | Excel Worksheet Functions | |||
| Conditional Average across worksheets | Excel Worksheet Functions | |||
| Conditional Statement with Multiple Arguments | Excel Worksheet Functions | |||
| Average a group, where grouping is Conditional on other col.??? | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
Linear Mode
