I have run a code to validate a calculated field in row14 against sum entries in row 15, such that the figure the enumerator will enter in Row15 should not be more the calculated individual sum in Row14.
Kindly assist me.
The xls below
Summation_issues.xlsx (12.1 KB)
@Sham_me, use the coalesce as outlined in this post discussed previously and that should solve your issue: