Sum if

[Batshon]

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

 

[Bob Phillips]

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)