Can you sum the amount of type a word appears?

[Scott_goddard]

Trying to sum the about of type a risk is open....So i need a statement to say

=SumIF(A1;A6=open,dont count)???

 

[Scott_goddard]

Sorted it - should have used Count If

=COUNTIF(B16:B4000,"*Open")

 

[getting old]

Use the countif function. countif(a1:a6,"open")

 

[Dianne]

Trying to sum the about of type a risk is open....So i need a statemen
to say

=SumIF(A1;A6=open,dont count)???

=COUNTIF(A1:A6,"open")