Countif with 2 criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to count if there's the number of ocurrences containing 100/101 but
when it does not have the word "cancel".

May be something like that:

COUNTIF(A1:A10,"*100/101*") but <>"cancel"

Please help.
 
One way:
=SUMPRODUCT((ISNUMBER(SEARCH("100/101",A1:A10))*ISERROR(SEARCH("cancel",A1:A10))))
 
=SUM(IF(ISNUMBER(SEARCH("100/101",A1:A100))*(NOT(ISNUMBER(SEARCH("cancel",A1:A100)))),1))

ctrl+shift+enter, not just enter
 

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

Excel Need Countifs Formula Help 0
Help needed on possible countif.. 3
Countif Multiple Criteria 5
counting a number of cells with 2 range criteria 3
Access Dcount (multiple criteria) 3
countifs criteria 4
COUNTIF on result of formula 4
COUNTIF with repeating pattern 3

Back
Top