Can you sum the amount of type a word appears?

Scott_goddard · Apr 16, 2010

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 · Apr 16, 2010

Sorted it - should have used Count If

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

getting old · Apr 16, 2010

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

Dianne · Apr 16, 2010

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")