Hi,
Working in Excel 2010 and I'm looking for a formula in column P which will autofill when new rows are inserted.
Working with row 10, the basic formula is:
P10=SUM(K10:O10)
where the Range(K10:P10) is formatted as Numeric, to 2 decimal places.
The formula should return "0.00" if the Range(K10:O10) contains no numeric values.
I have this (overcomplicated) formula from another project, but if I insert rows, then the formula does not fill down into those new rows:
=IF(OR(NOT(COUNT(I13))),0,SUM(K13:O13))
Many thanks.