Inconsistent Formula

[Andrewtickner]

Hi

Why do certain data cells show as Inconsistent formula alert when the contents are simply numerical data e.g. R3 and others don't?

Secondly, if I attempt to insert a blank row into the table it copies the Subtotal formula into each cell of the insert row.  The Clipboard is empty.

Many thanks

[#2]

@Andrewtickner 

That's since there were formulas like =+SUMPRODUCT($F$139:$F$142,#REF!) in these cells, Excel remembers initial formula. To avoid, select entire column, delete everything and start typing numbers.