Excel formula

[calamity]

Hi anyone out there good at excel formula's? What i need is a formula that adds up cells which equal 2 or above as 1

 

[Tomsk]

eh?
cell a1=2
cell a2=2
a1+a2=1

 

[DavidMarq]

Not sure that I understand the question but:

=SUMIF(A1:A10,">=2")

Will give the sum of all values grater than or equal to 2 for the range A1:A10

=COUNTIF(A1:A10,">=2")

Will give the number of values that are grater than or equal to 2 for the range A1:A10