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