Two Criteria with the COUNTIF function or somthing else?

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

Guest

I need a function that adds up a column of part of a string(ex. this_that,
and i just need to make sure "this" is in the string) and then another column
also has to be equal to "Closed". I haven't been able to get anything to
work, any ideas?
 
Assume A is your first column (the one that has this_that) and B is your
second column (the one with Closed in it):

=SUMPRODUCT(--ISNUMBER(SEARCH("this",A1:A10)),--(B1:B10="Closed"))

Just modify that to the range your data is actually in.
Does that help?
 
IT almost worked, but with the information you gave me i was able to work it
out. ISNUMBER gives true/false and so does B1:B10="Closed". So instead of
adding those together, multiply (true*true=1,true*false=0,ect.), so it would
look like this :

=SUMPRODUCT(ISNUMBER(SEARCH("this",A3:A30))*(J3:J30="closed"))

This gave me what i needed
So thank you for the help!
 
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

countifs Function not giving desired result with date criteria 2
using CountIF function or Array? 3
COUNTIF with two conditions 2
CountIf with And 0
COUNTIF....how to use >=0 but <9 as CRITERIA 3
COUNTIF with text criteria 2
Countif Function Using "AND" 3
Binary operator >> (?) 8

Back
Top