I need a formula for the following:

Lets say on "sheet 2" I need C16 to = C14+C15 off of "sheet 1" but it would
also need to = C23+C24+25+C26+C27+C28+C29 off of "sheet 1". If they do not =
each other then I would need a red flag, pop up error, or something to let me
know. Any help would be greatly appreciated.

Also if I did not post this question in the correct area please let me know.

Thanks!
jjwho