Using sum and if

[richardthelionheart]

"=IF(SUM(AI107:AK112>17),1, "x")
When I enter this into cell AL107 I keep getting #VALUE
Have tried to get the same result ie a result, using various means without success.
Thre's probably a simple solution which I'm not seeing.
Any help appreciated.

 

[Fluff]

You've got the bracket in the wrong place. Try
=IF(SUM(AI107:AK112)>17,1, "x")

 

[richardthelionheart]

You've got the bracket in the wrong place. Try
=IF(SUM(AI107:AK112)>17,1, "x")

Yes indeed, thank you.
I'm only guilty of very basic excel knowledge.

 

[Fluff]

Glad to help & thanks for the feedback