View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula omits adjacent cells

Hi,

Tools|Options - Error checking

The one that's annoying you is

'Formula omits cells in region' so un check it and any other you don't want.

Mike

"Ali" wrote:

Hi there
I have a spreadsheet with a SUM formula in Column k. Example K3 formula is
=Sum(D3:I3)
I clicked and dragged this formula all the way down to K 300

Across the spreadsheet now I am getting the green icon in the top left
corner of the cell, which says: Formula Omits adjacent cells.

This is random down column K and appears approximately 35 times.
i have checked the cell and the formula definitely includes the correct
cells in all cases.
there are no hidden columns.
Any idea why I a getting this randomly? and how do i correct.
Thanks
Ali