| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I average only if data in another column = "X"?
I know conditional formulas, but can't seem to program an average into an IF
formula. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I average only if data in another column = "X"?
Use SUMIF() / COUNTIF()
HTH, Bernie MS Excel MVP "NeedToKnowBasis" wrote in message ... I know conditional formulas, but can't seem to program an average into an IF formula. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I average only if data in another column = "X"?
What formula are you trying? What error are you getting, or what unexpected
result from what inputs? -- David Biddulph "NeedToKnowBasis" wrote in message ... I know conditional formulas, but can't seem to program an average into an IF formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) | |||
Linear Mode
