Formula omits adjacent cells

A

Ali

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
 
M

Mike H

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
 
A

Ali

Thanks Mike, I will do that. Any idea however, as to WHY I am getting this
message when i can't seem to find anything wrong with the spreadsheet?

cheers
Ali
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spurious Formula Omits Adjacent Cells 2
Help Writing a SUM Formula 5
Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Apparent Formula Problem 1
Formulas won't increment when dragging to adjacent cells? 3
Help with an Excel macro please? 6
Formula omits adjacent cells error message 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top