Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'd like to average the values in a column, excluding any cell that has a
comment, but still allow the same cell to be included in the calculation for that row. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do you exclude from calculation cells that have comments but at the same
time include them in the calculation? You need to re-think what you're asking.... Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "KenCQE" wrote: I'd like to average the values in a column, excluding any cell that has a comment, but still allow the same cell to be included in the calculation for that row. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I stated the problem that I need a solution for. Exclude the cells in a
column calculation but include them in a row calculation. "Dave F" wrote: How do you exclude from calculation cells that have comments but at the same time include them in the calculation? You need to re-think what you're asking.... Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "KenCQE" wrote: I'd like to average the values in a column, excluding any cell that has a comment, but still allow the same cell to be included in the calculation for that row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
Date Calculation to exclude weekends | Excel Worksheet Functions | |||
How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
Exclude non-numeric data from calculation | Excel Worksheet Functions | |||
calculation to exclude weekends | Excel Worksheet Functions |