Sounds like you want

=IF(SUM(B2:B5)=A1,"OK","Error")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Batshon" wrote in message
...
Hi,
in b2, am trying to put a formula that should :if(sum(B2:B5),=A1
otherwsie
Give me error
A1 is a
link from other sheet

i've put the following formula but its not working:
=IF(SUM(B3:B5)=A1,"Error")

A B
1 81
2 Position title 5
3 Position title 4
4 Position title 3
5 Position title 6

Thanks