IF Function when adding values

Hi,

When i try to include a sum as part of a logical test I get a VALUE! error. Please can you help?

The code I have been using is:

Please Login or Register  to view this content.

If i add a "+" sign between every value in column "B" it works fine, but when I use ":" to add the range it returns the error.

Thanks

Mike

That's great, thanks