I need some help please,
In Excel If the marks in all subjects are greater than 40 than sum them ,
but,if in any subject marks are less than 40 ,overall sum should be zero.
I mean give "0" if even one value is less than 40
& Give me the sum if all are greater than 40.