Can you sum the amount of type a word appears?

  • Thread starter Thread starter Scott_goddard
  • Start date Start date
S

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)???
 
Sorted it - should have used Count If

=COUNTIF(B16:B4000,"*Open")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum number range ignoring numbers formatted as text 0
"IF" help 2
SUMIF with criteria "<>" & "=" 4
Count If.....help 6
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Sumif or Better Alternative? 2
subtotal with sumif nested 1
sum of text positions 10

Back
Top