try this
=IF(SUM(J12:M12)-I12<=0,"Error",SUM(J12:M12)-I12)
Eva
"kara" wrote:

I need to create a function that will display an error if the sum of a range
of cells subtracted from another cell does not equal 0. I figure the first
part is
=SUM((J12:M12)-I12) that should total 0 and if it does not I need error to
be shown. Any advice/help greatly appreciated