Hello
Try
=IF((SUM(I14:I19))=(G20-H20),(G20-H20),""error"")

Because Excel calculates formulas with priority standards starting with the
operation symbols (such as +, -)

HTH
Cordially
Pascal

"Telegirl" a écrit dans le message de
news: ...
Several people have worked on this and I am sure it is something obvious,
but
the following If Statement will not work:

=IF(SUM(I14:I19)=(G20-H20),(G20-H20),"error")

It always returns 'error', even if the statement is true. Any
suggestions?

Thanks a lot!