The 2 was part of the ROUND function that I was using, and rounded the two
values each to 2 dps which was enough generally for me to be sure that the
two values were equal.

You can go with or without the ROUND but I'm generally belt and braces with
this kind of stuff and like to cover all the angles if I can.

Either
=IF(ROUND(SUM(H1:H100),2)=ROUND(SUM(A101:G101),2), SUM(A101:G101),"ERROR")

or without the round

=IF(SUM(H1:H100)=SUM(A101:G101),SUM(A101:G101),"ER ROR")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------