Cell A1 = £10,000
The usual way to calculate this would be:
=SUM(A2:A4)
E.G.
A2 = £5,000
A3 = £2,500
A4 = £2,500
However, I want my colleagues to enter the numbers without automating the formula "=SUM(A2:A4)".
However, I don't want to autosum cell A1, but I want to create or use a formula that will highlight that cell A1 doesn't equal A2:A4.
Any advice on how to do this?
Bookmarks