View Single Post
  #1   Report Post  
Tony
 
Posts: n/a
Default Sum function not working correctly in Excel (Skips Cell)

I have one cell that is not included in a sum function. This repeats in
several worksheets. e.g. =SUM(C6:C11) Cell C7 is not added in the list.
If I type in the formula =C6+C7+C8+C9+C10+C11 it will give the correct result.

Thanks in Advance