Autosum error

[blackie42]

Hi,

Am getting an error message 'GROSS VALUE ERROR'

'The gross value cannot be less than the net value'

Never seen this before - thought it maybe that I was adding numbers in a column and some of them were zeros but even adding the positives only still gives me the same message.

Any ideas what is causing this?

thanks

[blackie42]

I pasted the sheet from another - I redid it using 'values' only and it seems to work now.