i have a spreadsheet. The ENTRY and EXIT should tally.
ENTRY----total of col A:D is in E3.
EXIT---- total of col G:J is in K3.
i expect to get E3=k3
cell K3 is formatted as the sum of G:J
when i enter a data wrongly in anywhere between the cells G:J a warning should come in col K3 (of course after entering data in all the four cells G:J).the idea is the number in entry should tally with that of the exit. is it possible?
the excel file is attached.