Can you sum the amount of type a word appears?
in [Functions]
|
From: Scott_goddard on 16 Apr 2010 10:12 Trying to sum the about of type a risk is open....So i need a statement to say =SumIF(A1;A6=open,dont count)???
From: Scott_goddard on 16 Apr 2010 10:31 Sorted it - should have used Count If =COUNTIF(B16:B4000,"*Open") "Scott_goddard" wrote: > Trying to sum the about of type a risk is open....So i need a statement to say > > =SumIF(A1;A6=open,dont count)???
From: getting old on 16 Apr 2010 10:34 Use the countif function. countif(a1:a6,"open") "Scott_goddard" wrote: > Trying to sum the about of type a risk is open....So i need a statement to say > > =SumIF(A1;A6=open,dont count)???
From: Dianne on 16 Apr 2010 10:39 Scott_goddard;701145 Wrote: > Trying to sum the about of type a risk is open....So i need a statement to say > > =SumIF(A1;A6=open,dont count)??? =COUNTIF(A1:A6,"open") -- Dianne ------------------------------------------------------------------------ Dianne's Profile: http://www.thecodecage.com/forumz/member.php?u=1755 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196163 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: excel 2007 macro recorded pivot table Next: Identify the windows just below the menu |