I am trying to sum cells F2 to N2 but if any cell value exceeds 35,I want to limit it to 35. =sum(min(35,f2):min(35,n2)) doesn't work and it won't accept curly brackets. I could get round this by adding another sheet that does the min(35,f2) etc bit but would prefer not to. Can anyone help?
02nd Feb 2012 15:01