View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Exclude Cell from Calculation

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.